Syntax Diagrams for Data Pump Import
출처: Oracle Help CenterImpInit
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
댓글 없음:
댓글 쓰기