Generating Object Reverse Engineering (DDL Backup) in Oracle Database 11g

Views: 834
Reading Time: <1 minute

Staff,
Good night!

Today I will show you how to reverse engineer objects in Oracle Database, also known as DDL backup for creating objects.

To download the scripts I will demonstrate, go to This link.

To use them, you should be using Oracle SQL * Plus, preferably the GUI, which is more convenient to run scripts and, in my opinion, is the best tool for administering Oracle databases. Although it is all command line, it has many quick and practical shortcuts to the daily life of Oracle DBA.

I will briefly describe the scripts:

  • backup_object.sql = Reverse engineer the desired object by entering Object type, owner and name and save the result to the spool (output file)
  • backup_object2.sql = Generates reverse engineering of desired object by entering name only and displays on screen
  • backup_object3.sql = Reverse engineer the desired object by entering Object type, owner and name and display on screen
  • backup_sequence.sql = Reverse engineer all owner sequences and save the result to the spool.

In all scripts, reverse engineering of permissions, public and private synonyms, indexes, and triggers (with the exception of the sequence script) is also generated.

That's it folks!