Creating an Oracle Database

<back to oca>

You use DBCA that gives you five options:

  1. create a database
  2. configure database options
  3. delete a database
  4. manage templates
  5. configure Automatic Storage Management (new in 10gR2)

Data dictionary is a set of tables owned by user SYS describing database structure. Data dictionary is metadata: data about data. It is created during “CREATE DATABASE” , then, “catalog.sql” create the “data dictionary views”, this is also part of database creation.

Use DBCA to Create a database

Use DBCA to Delete a database

Use DBCA to manage Templates

See “2 Day DBA”

there are two types of templates:

  1. SEED, whose files have extension .dbc this template contains also data files and online redolog in a compressed file with extenstion .dfj . You can add log file groups but not datafiles
  2. NON-SEED whose files have extension .dbt

Templates can be made by

  1. existing templates
  2. existing database (structure only)
  3. existing database (structure and data)

Templates are stored in the following directory:

ORACLE_HOME/assistants/dbca/templates

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: