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.

Purpose:

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 : https://www.facebook.com/ktexperts/
LinkedIn : https://www.linkedin.com/company/ktexperts/
Twitter : https://twitter.com/ktexpertsadmin
YouTube : https://www.youtube.com/c/ktexperts
Instagram : https://www.instagram.com/knowledgesharingplatform

 

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

Add Comment