Guys,
Goodnight!

Today I'm going to show you how to reverse engineer objects in Oracle Database, also known as DDL backup to create objects.

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

To use them, you must be using Oracle SQL*Plus, preferably the GUI, which is more practical for executing scripts and, in my opinion, is the best tool for managing Oracle databases. Despite being all command line, it has many practical and quick shortcuts for the day-to-day life of the Oracle DBA.

I will give a brief description of the scripts:

  • backup_object.sql = Generates reverse engineering of the desired object, informing object type, owner and name and saves the result in the spool (output file)
  • backup_object2.sql = Generates reverse engineering of the desired object, providing only the name and displays it on the screen
  • backup_object3.sql = Generates reverse engineering of the desired object, informing object type, owner and name and displays it on the screen
  • backup_sequence.sql = Generates reverse engineering of all owner sequences and saves the result in the spool.

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

That's it folks!