Import Oracle Database: Difference between revisions
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
==Create Directory== | ==Create Directory== | ||
<pre>create or replace directory DB_IMPORT as '/u01/app/oracle/admin/E1Local/import/';</pre> | <pre>SQL> create or replace directory DB_IMPORT as '/u01/app/oracle/admin/E1Local/import/';</pre> | ||
==Import== | ==Import== | ||
<pre>expdp system/password Directory=DB_EXPORT dumpfile=full logfile=O1_MF_99GMP1FC_.CTL</pre> | <pre>expdp system/password Directory=DB_EXPORT dumpfile=full logfile=O1_MF_99GMP1FC_.CTL</pre> | ||
Revision as of 04:28, 12 October 2014
Create Directory
SQL> create or replace directory DB_IMPORT as '/u01/app/oracle/admin/E1Local/import/';
Import
expdp system/password Directory=DB_EXPORT dumpfile=full logfile=O1_MF_99GMP1FC_.CTL