Posts

Showing posts from December, 2011

Oracle impdp

# impdp system/ @>ORACLE_SID> commit=y full=y show=y Location: SQL> select owner, directory_name, directory_path from dba_directories where directory_name like 'DATA_PU%'; OWNER DIRECTORY_NAME ------------------------------ ------------------------------ DIRECTORY_PATH -------------------------------------------------------------------------------- SYS DATA_PUMP_DIR /u01/app/oracle/admin/linpe9004/dpdump/