2015년 6월 26일 금요일

Oracle's Data Pump Import: impdp

Syntax Diagrams for Data Pump Import

출처: Oracle Help Center

ImpInit


ImpStart




ImpModes



ImpOpts



ImpFilter



ImpRacOpt



ImptRemap



ImpFileOpts



ImpNetworkOpts



ImpDynOpts



ImpDiagnostics





examples)

$ impdp scott/tiger attach=import_job_name

$ impdp scott/tiger directory=datadumpdir dumpfile=datafile.dmp logfile=logdir:import.log full=yes

$ impdp scott/tiger directory=datadumpdir dumpfile=datafile.dmp full=yes transform=segment_attribute:n

$ impdp scott/tiger directory=datadumpdir dumpfile=datafile.dmp full=yes transform=segment_attribute:n table_exists_action=truncate

$ impdp scott/tiger directory=datadumpdir dumpfile=datafile.dmp transform=segment_attribute:n table_exists_action=append tables=scott.tablename

$ impdp scott/tiger directory=datadumpdir dumpfile=datafile.dmp transform=segment_attribute:n table_exists_action=skip schemas=scott

$ impdp scott/tiger directory=datadumpdir dumpfile=datafile.dmp transform=segment_attribute:n table_exists_action=replace tablespaces=data_tbs

댓글 없음: