Database Reference
In-Depth Information
MAXINSTANCES is basically optional and used specifically in
Oracle RAC (Real Application Cluster). The default is 1, if not
specified.
ARCHIVELOG or NOARCHIVELOG
With this clause you can make the database to run in archive log
mode or no archive log mode. In archive log mode, Oracle
Instance makes sure that redo log files get archived to
ARCHIVE_LOG_DEST location before they get overwritten.
You can also switch between these two modes later after the
creation of database using the ALTER DATABASE statement.
CHARACTER SET defines the character set that the database
uses to store data.
NATIONAL CHARACTER SET this clause is optional and is
used to store data in columns specifically defined as NCHAR,
NCLOB or NVARCHAR2.
Now let's look at the real world example as provide below.
CREATE DATABASE mydb1
CONTROLFILE REUSE
LOGFILE
GROUP 1
('/mydatabases/mydb1/log01a.log',
'/mydatabase02/mydb1/log01b.log') size 50M,
GROUP 2
('/mydatabases/mydb1/log02a.log',
'/mydatabase02/mydb1/log02b.log') size 50M,
GROUP 3
('/mydatabases/mydb1/log03a.log',
'/mydatabase02/mydb1/log03b.log') size 50M,
DATAFLE '/mydatabases/mydb1/system.dbf' SIZE 250M
AUTOEXTEND ON NEXT 10M MAXSIZE 500M
UNDO TABLESPACE undotab
DATAFILE '/mydatabases/mydb1/undotab.dbf' SIZE 50M
DEFAULT TEMPORARY TABLESPACE temptbs
TEMPFILE '/mydatabases/mydb1/temptbs.dbf' size 75M
EXTENT MANGEMENT LOCAL
CHARACTER SET US7ASCII
Search WWH ::
Custom Search