Oracle 7.3 - Oracle 23ai 20+ years of experience Version (Released: )

Oracle database structure backup

09 Feb 2017

Oracle database structure backup and how it can be established will be discussed in this article. In this example, we would like to show you a sample how to use a Windows batch file to execute the Reverse DB Engineer on a regular basis and store each resulting script as a date-stamped file for future reference.

Note the RevDDL executable has been passed two parameters: the name, including path, of the resulting .sql file, and the logon credentials of the user.

The name of the generated .sql file containing your Oracle database structure backup in this case is


You may need to tailor the batch file to accommodate your own date format. Here, it is YYYY-MM-DD. Just type “date” from the command prompt to find out what it is on your machine.


See how it works!

Explore possibilities of KeepTool.