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!

Extracting DDL From a Full DB Export (.dmp)

Michael8773Dec 13 2016 — edited Dec 14 2016

Hello,

While it is possible to extract finite sets of database objects on exports, is it possible to do this cleanly on an import (having a full database export .dmp)?

For instance, with just the SQLFILE and INCLUDE options I can generate the SQL for just one SCHEMA. Example snippet:

SQLFILE=impDatabase.ddl.txt
INCLUDE=SCHEMA:"='SCOTT'"

I cannot yet filter it easily though to grab just an entire subclass of objects from the export. For instance, I have not figured out how to just get PROCEDURE related objects and not everything else for a schema even using something like this:

SQLFILE=impDatabase.ddl.txt
INCLUDE=SCHEMA:"='SCOTT'"
INCLUDE=PROCEDURE

What am I missing, how can I get all the PROCEDURE (or INDEX or CONSTRAINTS...) creation commands for a schema from a full database export file?

Thanks,

-Michael

This post has been answered by michael.sakayeda-Oracle on Dec 13 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 11 2017

Added on Dec 13 2016

#database-key-features, #export, #export-import-sql-loader-external-tables

5 comments

2,623 views