Data pump

Data pump
Fast Performance: Data Pump Export에서 direct path method를 사용시 single stream data unload에서 기존의 export보다 2배가 빠르다. Data Pump Import에서는 single stream의 data load 시 기존의 import보다 15~45배 빠르다고 한다.

C:\> sqlplus /nolog
SQL> conn sys/oracle as sysdba;
SQL> create directory dump as 'C:\Dump';
SQL> grant read, write on directory dump to public;
SQL> host

C:\> expdp system/oracle dumpfile=full.dmp logfile=export.log directory=dump full=y job_name=data_export

만약 중간에 끊기면(Ctrl+C)
Export> stop_job ---> job을 정시킨다.
이 작업을 정지하겠습니까([예]/아니오): 예

C:\> sqlplus /nolog
SQL> conn sys/oracle as sysdba;
SQL> select owner_name, job_name, operation, job_mode, state from dba_datapump_jobs;
SQL> exit

C:\> expdp system/oracle attach=data_export

C:\> sqlplus /nolog
SQL> conn sys/oracle as sysdba;
SQL> select owner_name, job_name, operation, job_mode, state from dba_datapump_jobs;

Export> start_job ---> job을 다시 시작한다.
Export> status

C:\>

C:\> impdp system/oracle directory=dump dumpfile=full.dmp schemas=scott logfile=import.log

-----------------------------------------------------------------------------------
-----------------------------------------------------------------------------------

2011년 10월 27일 추가 구문들

C:\> sqlplus /nolog
SQL> conn sys/oracle as sysdba;
SQL> create directory dump as 'C:\Dump';
SQL> grant read, write on directory dump to public;
SQL> host

C:\> expdp scott_d_p/scott_d_p dumpfile=dp_scott.dmp logfile=db_scott.log directory=dump schemas=scott_d_p job_name=exp_d_p

C:\> expdp scott_t_p/scott_t_p dumpfile=dp_scott.dmp logfile=db_scott.log directory=dump schemas=scott_t_p job_name=exp_c_p