Oracle 7.3 - Oracle 21c Windows 11 compatible 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

D:\MyDDLs\2017_01_09_hr_pdbora12c4.sql

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.