Invoke Original Export/Import Utiities in Oracle

Q

How To Invoke Original Export/Import Utilities in Oracle?

✍: FYIcenter.com

A

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
......

 

Loading and Exporting Data in Oracle

⇒⇒Oracle Database Tutorials

2016-10-15, 228👍, 0💬