Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

expdp/impdp metadata in clear text

jhowardMay 2 2013 — edited May 2 2013
11.2.0.1. Did a quick search on the forums and on google and couldn't find what i'm looking for.

Ran the following:
expdp full=y content=metadata_only dumpfile=exp_full_metadata.dmp logfile=exp_full_metadata.log exclude=table exclude=index 
Now i want to get that metadata into some kind of clear text file, so I can review and copy out certain sections. With IMP we could just display the ddl on the screen and not import it - is there a similar way to do this with IMPDP?

for example with Imp we had: Import Parameters "Show": http://docs.oracle.com/cd/B10500_01/server.920/a96652/ch02.htm#1014036
SHOW*
Default: n
When SHOW=y, the contents of the export file are listed to the display and not imported. The SQL statements contained in the export are displayed in the order in which Import will execute them.
The SHOW parameter can be used only with the FULL=y
This post has been answered by Richard Harrison . on May 2 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 30 2013
Added on May 2 2013
3 comments
3,060 views