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
......
⇒ ODBC Drivers and DSN Configuration for Oracle
⇐ Original Export/Import Utilities in Oracle
2016-10-15, 2384🔥, 0💬
Popular Posts:
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How to calculate the storage size of a JSON (JavaScript Object Notation) value using the JSON_STORAG...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...