Import Oracle Database: Difference between revisions

Revision as of 02:31, 14 October 2014

SQL> create or replace directory DB_IMPORT as '/u01/app/oracle/admin/E1Local/import/';

impdp system/password@E1Local directory=DB_IMPORT DUMPFILE='JDECTL910.DMP' LOGFILE='imp_jdectl910.log'

Revision as of 04:32, 12 October 2014 (view source) Nicolas Rollin (talk \| contribs) (→‎Import) ← Older edit		Revision as of 02:31, 14 October 2014 (view source) Nicolas Rollin (talk \| contribs) (→‎Import) Newer edit →
Line 3:		Line 3:

	==Import==		==Import==
	<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>		<pre>impdp system/password@E1Local directory=DB_IMPORT DUMPFILE='JDECTL910.DMP' LOGFILE='imp_jdectl910.log'</pre>