How to Extract DDL Statements From Oracle Dump Using Toad?

How to Extract DDL Statements From Oracle Dump Using Toad?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • Toad
  • 1 min read

In Toad, follow these steps to extract DDL statements from Oracle Dump (DMP file).

Steps to Extract DDL and Create SQL Script From DMP File in Toad

  1. Open the Toad for Oracle and login to the database.
  2. Then click on the menu Database > Export > Export File Browser.
  3. An Export File Browser window will open.
  4. Click on the Open File icon to open the DMP file as shown in below image.

extract DDL statements from Oracle DUMP in Toad

  1. After selecting the DMP file from the file browser, it will explore the whole file contents as shown above.
  2. Then select the Schemas node and do the right click on it.
  3. From the shortcut menu, choose Export DDL for Selected Nodes to extract DDL statements for that DUMP file.
  4. Then a window will pop up to ask you for the path for the SQL file.
  5. Specify the file name and path and click on the OK button to extract.

You can also click on any particular object to extract the DDL for it.

See also: