Generate DDL from a Data Pump Export File By Shadab Mohammad • Mar 9, 2015 • No comments — 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 Share this:Click to share on Twitter (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to share on Facebook (Opens in new window)Click to share on Tumblr (Opens in new window)Click to share on WhatsApp (Opens in new window) Category: Uncategorized Tags: 10gR2 • 11gR2 • Data Pump • DL • generate • Get • oracle • SQL • Statement