특정 테이블스페이스 백업
expdp ACOMPANY/acompany directory=dpump_dir2 dumpfile=expdp_acompany_data_0216.dmp logfile=expdp_alldata_0216.log tablespaces=LGEIC_01 job_name=a
백업파일에서 특정 테이블만 복구
impdp ACOMPANY/acompany dumpfile=expdp_acompany_data_0216.dmp directory=dpump_dir2 logfile=expdp_20160216.log tables=departments TABLE_EXISTS_ACTION=APPEND
백업파일에서 다른 유저(스키마)로 복구
impdp ACOMPANY/acompany dumpfile=expdp_acompany_data_0216.dmp directory=dpump_dir2 logfile=expdp_20160216.log remap_schema=ACOMPANY:kinx TABLE_EXISTS_ACTION=APPEND
백업파일에서 특정 table을 다른 유저(스키마)로 복구
impdp ACOMPANY/acompany dumpfile=expdp_acompany_data_0216.dmp directory=dpump_dir2 logfile=expdp_20160216.log remap_schema=ACOMPANY:kinx tables=departments TABLE_EXISTS_ACTION=APPEND
전체 백업
expdp system/oracle dumpfile=full.dmp directory=dump full=y job_name=Lucie
|