Data Pump Impdp show=y Replaced with SQLFILE Option

Most of the legacy mode options will work in the data pump with its corresponding options. In legacy mode (imp utility) we have show=y option to spool the content of the dump file into sql scripts without doing the actual import. The same command can be used in data pump impdp also but it will get replaced with sqlfile option.

See one example below.

$ impdp dumpfile=tab_exp.dmp logfile=imp_tab_exp.log full=y directory=exp_dir show=y

Import: Release 11.2.0.3.0 - Production on Thu Feb 13 11:40:29 2014 

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved. 

Username: / as sysdba 

Connected to: Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

Legacy Mode Active due to the following parameters:

Legacy Mode Parameter: "show=TRUE" Location: Command Line, Replaced with: "sqlfile=tab_exp.sql"

Master table "SYS"."SYS_SQL_FILE_FULL_01" successfully loaded/unloaded

Starting "SYS"."SYS_SQL_FILE_FULL_01":  /******** AS SYSDBA dumpfile=tab_exp.dmp logfile=imp_tab_exp.log full=y directory=exp_dir sqlfile=tab_exp.sql

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Job "SYS"."SYS_SQL_FILE_FULL_01" successfully completed at 11:40:38
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google