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.

 

See how it works!

Explore possibilities of KeepTool.

i,g

Try KeepTool now!

KeepTool’s Oracle database tools have been developed by database application developers for database application developers as well as database administrators and application support. Based on the feedback and requests of our customers, we have been continuously improving our tools for more than 20 years and strive to improve with each new release.
Download KeepTool