Import Oracle Database

From Objectif Client Inc

Revision as of 04:32, 12 October 2014 by Nicolas Rollin (talk | contribs) (→‎Import)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

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'

Retrieved from "http://wiki.objclt.ca/wiki/index.php?title=Import_Oracle_Database&oldid=48"