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, 1662🔥, 0💬
Popular Posts:
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...