Use the Database Templates page to select a template. The Database Configuration Assistant shows this page when you are creating a new database and when you are managing your database templates.
Database templates are XML files on your local hard disk that store database configuration information. Database Configuration Assistant provides several prepackaged templates, but you can also create your own templates.
Templates provide the following benefits:
Create a duplicate database without specifying all the database parameters again.
Quickly change database options from the template settings.
Share templates by copying the template from one machine to another.
A template may or may not contain data files. The following sections provide more details about templates with and without data files.
Templates without data files contain only the structure of the database and gives you full control to specify and change all database parameters. You will also be able to save the database creation information as a script.
Note: If you select a template without data files, database creation will take longer because all scripts must be run to create the schema.
Templates that include data files contain both the structure and the physical data files of the existing database. If you select a template that also includes data files, the database is created faster since the schema is present in the data files. Also, all logfiles and control files are automatically created for the database. You can add/remove control files, log groups, change the destination and name of data files.
Important: If you select a database template that includes data files, you will not be able to add or remove data files, tablespaces, or rollback segments. Selecting this type of template allows you to change the following:
The name of the database
Destination of the data files
Controlfiles
Redo log groups
Initialization parameters
After you select a template from the list, to find out complete details about the template, click Show Details. The detailed report is presented in HTML format. It shows the selected template's database creation parameters. Included in the report is information about initialization parameters, control files, data files, tablespace, database options, variables (if used), custom scripts (if used), and redo log groups.
Copyright © 1996, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.