Generate DDL from a Data Pump Export File

— Get DDL from impdp —

The below command will not import the dump, but will just create a .sql file with the DDL statements

impdp system/**** directory=import_dir dumpfile=IMPORT.DMP sqlfile=getddl.sql

Leave a Reply