Getting DDL Using Data Pump 1

[tekdudedude]

Hello,

Though at this point there are various ways to get DDL for schema objects, is there a way to get DDL (for tables,indexes,procedures,triggers etc.) using the Data Pump?

Yep, in the the legacy imp\exp you can use IndexFile= and there also is dbms_metadata.get_ddl().

I was wondering if the Data Pump could do it and how.

Thanks,

TD

 

[SantaMufasa]

TekDudeDude,

Check out the "SQLFILE=<file name>", parameter of "impdp", which should (as Import Data Pump Help suggests) give you:

...all the SQL DDL to a specified file.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[tekdudedude]

Santa,

I really like how Data Pump does this - very useful. Thanks for posting!

TD