Import Oracle Database: Difference between revisions
Jump to navigation
Jump to search
(→Import) |
|||
| Line 3: | Line 3: | ||
==Import== | ==Import== | ||
<pre> | <pre>impdp system/password@E1Local transport_datafiles='/u01/app/oracle/admin/E1Local/import/JDECTL910.DBF' directory=DB_IMPORT DUMPFILE='JDECTL910.DMP' LOGFILE='impjdectl910_2log'</pre> | ||
Revision as of 04:32, 12 October 2014
Create Directory
SQL> create or replace directory DB_IMPORT as '/u01/app/oracle/admin/E1Local/import/';
Import
impdp system/password@E1Local transport_datafiles='/u01/app/oracle/admin/E1Local/import/JDECTL910.DBF' directory=DB_IMPORT DUMPFILE='JDECTL910.DMP' LOGFILE='impjdectl910_2log'