Import Oracle Database

From Objectif Client Inc

Revision as of 02:32, 14 October 2014 by Nicolas Rollin (talk | contribs) (→‎Create Directory)

(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/';

Move your exported file (files.dmp) in it.

Import

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

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