Site icon EasyOraDBA

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

Exit mobile version