What are seed templates?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

What are seed templates?

Rating:

Seed templates are XML-based templates used to create Oracle databases. Seed templates are used in DBCA to make clones of existing (seed) databases. The information in seed templates are as follows:

1. Database options


2. Initialization parameters


3. Storage attributes (data files, redo logs, control files, and tablespaces)

The structure and the physical data files of an existing database are both included in seed templates. Database creation is faster through the use of seed templates because the physical files and schema of the database have already been created. Using seed templates, only the following information can be edited:

1. Name of the database


2. Destination of the data files


3. Number of control files


4. Number of redo log groups


5. Initialization parameters

Other changes can be made after database creation using custom scripts, which are generally invoked by DBCA, command line SQL statements, or the Oracle Enterprise Manager.

The template definition for the seed templates is normally stored in the /assistants/dbca/templates directory on Unix and in the %ORACLE_HOME%\assistants\dbca emplates directory on Windows operating systems.
The data files and redo logs in the seed templates are stored as files having .dfj extension and the corresponding .dfj file's location is stored in the file having .dbc extension.

Following are the advantages of seed templates:

1. They save time.


2. There is no need to specify the parameters twice.


3. The editing work can be easily done in the database.


4. They are easy to share, i.e., they are easily copied from one computer to another.

Rating: