How to Generate DDL from existing dumpfile

Share via:

Hello everyone,

In this article, we will learn Generating DDL using existing dumpfile.

To generate DDL of a schema or table  from a dumpfile we use a parameter called SQLFILE.


SQLFILE is a paramater which can be used in IMPDP utility to generate DDL of schema or  table .

Syntax : 

Demonstration : 

Step 1:

Perform an full schema export of SCOTT.

Step 2:

Drop the SCOTT schema

Step 3:

Use the SQLFILE parameter while performing IMPDP utility.

Note :  By using SQLFILE parameter in IMPDP untilty , The data will not be  import to database, it just creates generate DDL in specified directory.

Step 4 :

Check the DDL script

Step 5:

We can execute the script to Create schema with objects(Metadata).

Please test above document in you LAB environment .

Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates

KTEXPERTS is always active on below social media platforms.

Facebook :
LinkedIn :
Twitter :
YouTube :
Instagram :


Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 5.00 out of 5)

Add Comment