DBCA-templates For simple

enter the following at a command prompt:

dbca

CMD->DBCA->the start page will appear。

A：Using DBCA to Create a Database

To accept all the default parameters,you can click 【Finish】at any step.

 1：Templates

 

• Seed templates

   

• Non-seed templates

Seed .dbc （Seed templates ）----This type of template contains both the structure and the physical datafiles of an existing (seed) database.

You can change only the following:

• Name of the database

   

• Destination of the datafiles

   

• Number of control files

   

• Number of redo log groups

   

• Initialization parameters

The datafiles and redo logs for the seed database are stored in a compressed format in another file with a .dfb extension. The corresponding .dfb file’s location is stored in the .dbc file.

 

Non-seed .dbt （Non-seed templates） This type of template is used to create a new database from scratch. It contains the characteristics of the database to be created.

Oracle provides templates for the following environments:

Data Warehouse

Users perform numerous, complex queries that process large volumes of data. Response time, accuracy, and availability are key issues.

Transaction Processing

Many concurrent users performing numerous transactions requiring rapid access to data. Availability, speed, concurrence, and recoverability are key issues.

 General Purpose

This template creates a database designed for general purpose usage. It combines features of both the DSS and OLTP database templates.

Custom Database

This template allows you maximum flexibility in defining a database.

Creating Templates Using DBCA

■From an existing template

■From an existing database (structure only)

■From an existing database (structure as well as data)

There are two types of templates: