Creating several databases with the same parameters can be a time consuming task if the DBA has to define the same parameters each time. The DBA can save time when creating the database through templates. The templates can contain only a definition file, or they can contain both a definition file and the seed database files, which can be used to create a new database by means of a cloning procedure.

Template management operations

There are two kind of template management operations; create and delete a database template. When creating a new database template, there are three ways to create a new template, from an existing template, and from an existing database which may or may not include the seed database.

The options available to create templates are:

• Create a template From an existing template (A). This takes an existing definition which you can further modify and save with a different name.

• Create a template From an existing database (structure only)(B) ....