advertisements
_____________________________________________________________________________________________________________________
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
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment