Creating a Database Template from an Existing Template for the DBCA Utility

To create a database template from an existing template:

1. Run the DBCA utility as follows:

   <ORACLE_HOME>\bin\dbca

   where:

   <ORACLE_HOME>: A path ot Oracle Home. For example, "C:\oracle\product\11.2.0\db_1".

2. On the Welcome screen, select Next.

   Note: Select Next on each screen to advance to the next step in the sequence.

3. On the Database Operations screen, select Manage Templates.
4. On the Template Management screen, select the following options:
   • Create a database template and
   • From an existing template
5. On the Database Templates screen, select General Purpose or Transaction Processing Template.
6. On the Template Properties screen enter the following information:
   • Name: A name for the new template. For example, "General_Purpose_My_Characterset".
   • Description: A description of the new template.
   • Data file Backup: The folder location of the data file backup.
7. On the Storage Locations screen, select the following options:
   • Use Database File Locations from Template.
   • Specify Flash Recovery Area
   • Flash Recovery Area and retain the default Flash Recovery folder location.
   • Flash Recovery Area Size: Enter an MB value that is at least three times the area of the database size.
8. On the Initialization Parameters screen:
   • Select the Character Sets tab.
   • Select Use the default option to use the Database Character Set, WE8MSWIN1252.
9. On the Summary screen, review the information.
10. Select Finish.
11. On the Confirmation screen, review the summary.
12. Select OK to create the custom template.

    You can now use the custom template in the instance creation command instead of the template name "General_Purpose.DBC". For detailed instructions, see Creating the Oracle Instance.

Legal Notices | Your Privacy Rights
Copyright © 1998, 2020

Last Published Tuesday, December 8, 2020