How to Extract DDL Statements From Oracle Dump Using Toad?

  • Post author:
  • Post category:Toad
  • Reading time:2 mins 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:

Vinish Kapoor

An Oracle Apex Consultant, Oracle ACE, and founder of foxinfotech.in and orclqa.com a question and answer forum for developers.