Create Your Databases by Loading Backups

If you do not intend to rebuild your production environment, you may prefer to create your test databases with the for load option of the create database command. This makes your test databases more representative of the current production environment in terms of fragmentation and density.

Follow these steps:

  1. Create the database with the for load option of the create database command.

  2. Load the backups you made of the production database.

  3. Issue the online database command. This command automatically upgrades the database if it is not at the 12.5 level.

For command syntax, see the Reference Manual.