Import Oracle Database: Difference between revisions
Jump to navigation
Jump to search
(Created page with "==Create Directory== <pre>expdp system/password Directory=DB_EXPORT dumpfile=full logfile=O1_MF_99GMP1FC_.CTL</pre> ==Import== <pre>expdp system/password Directory=DB_EXPORT...") |
|||
| Line 1: | Line 1: | ||
==Create Directory== | ==Create Directory== | ||
<pre> | <pre>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
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