Database Reference
In-Depth Information
CREATE DATABASE [database name]
[CONTROLFILE REUSE]
[LOGFILE [GROUP integer] file specification]
[MAXLOGFILES integer]
[MAXLOGMEMBERS integer]
[MAXLOGHISTORY integer]
[MAXDATAFILES integer]
[MAXINSTANCES integer]
[ARCHIVELOG|NOARCHIVELOG]
[CHARACTER SET charset]
[NATIONAL CHARACTER SET charset]
[DATAFILE filespec [autoextend]]
[DEFAULT TEMPORARY TABLESPACE filespec]
[UNDO TABLESPACE tablespace DATAFILE files]
[SET TIME_ZONE [time_zone_region]];
Let's look at the items in this statement one by one. Database
name you specified in the initialization parameter file using
DB_NAME parameter. If you omit the name, the one you
specified in the parameter file will be used.
Control file reuse means that the control file specified in the
initialization parameter file should be reused.
Log file group is the place where we specify the redo log files
and the group they belong. Things will get clearer to you once
we look at the real world example.
MAXLOGFILES defines the maximum number of redo log
files/redo log groups that can ever be created in the database.
Similarly, MAXLOGMEMBERS defines the limit for redo log
members per redo log group.
MAXLOGHISTORY specifies the maximum number of archive
redo log files for automatic media recovery.
AUTOEXTEND enables or disables the automatic extension of
SYSTEM tablespace data files.
MAXDATAFILES defines the maximum number of data files
that can ever be added to the database.
Search WWH ::
Custom Search