Collections:
Invoke Original Export/Import Utiities in Oracle
How To Invoke Original Export/Import Utilities in Oracle?
✍: FYIcenter.com
If you really want to run the original export import utilities, you can still go to "bin" directory of the Oracle server path and run the "exp" or "imp" command. The tutorial exercise below tells you how to run the export and import utilities in help modes:
>cd \oraclexe\app\oracle\product\10.2.0\server\BIN >exp help=y You can let Export prompt you for parameters by entering the EXP command followed by your username/password: Example: EXP SCOTT/TIGER Or, you can control how Export runs by entering the EXP command followed by various arguments. To specify parameters, you use: Format: EXP KEYWORD=value or KEYWORD=(value1,value2,...,valueN) Example: EXP SCOTT/TIGER GRANTS=Y TABLES=(EMP,DEPT,MGR) or TABLES=(T1:P1,T1:P2), if T1 is partitioned table ...... >imp help=y ......
2016-10-15, 814👍, 0💬
Popular Posts:
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
What is mscorsvw.exe - Process - Microsoft .NET Framework NGEN in SQL Server? Process mscorsvw.exe i...
How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to ...
Where Is the Export Dump File Located in Oracle? If you are not specifying the dump directory and fi...