CREATE DATABASE

Create a database.

Syntax:

   CREATE DATABASE database_name options

Options:

   DATAFILE filespec AUTOEXTEND OFF
   DATAFILE filespec AUTOEXTEND ON [NEXT int K | M] [MAXSIZE int K | M]
   MAXDATAFILES int
   EXTENT MANAGEMENT LOCAL
   DEFAULT TEMPORARY TABLESPACE tablespace [TEMPFILE filespec] [EXTENT MANAGEMENT LOCAL] [UNIFORM [SIZE int K | M]]
   UNDO TABLESPACE tablespace [DATAFILE filespec]
   LOGFILE [GROUP int] filespec
   MAXLOGFILES int
   MAXLOGMEMBERS int
   MAXLOGHISTORY int
   MAXINSTANCES int
   ARCHIVELOG | NOARCHIVELOG
   CONTROLFILE REUSE
   CHARACTER SET charset
   NATIONAL CHARACTER SET charset
   SET TIMEZONE = 'time_zone_region'
   SET TIMEZONE = '{+|-} hh:mm'
   FORCE LOGGING
   USER SYS IDENTIFIED BY password
   USER SYSTEM IDENTIFIED BY password

If more than one DATAFILE or LOGFILE is to be specified - several 'filespecs' can be included in one clause separated with commas e.g. DATAFILE filespec1, filespec2, filespec3

If you do not specify both system passwords, Oracle will create the default passwords "change_on_ install" for SYS and "manager" for SYSTEM.

After creating the database, you can change between ARCHIVELOG mode and NOARCHIVELOG mode with the ALTER DATABASE statement.

Example
-- Create a database with the SID of TEST and char set WE8ISO8859P1

CREATE DATABASE TEST
LOGFILE 'E:\OraData\TEST\LOG1TEST.ORA' SIZE 2M,
'E:\OraData\TEST\LOG2TEST.ORA' SIZE 2M,
'E:\OraData\TEST\LOG3TEST.ORA' SIZE 2M,
'E:\OraData\TEST\LOG4TEST.ORA' SIZE 2M,
'E:\OraData\TEST\LOG5TEST.ORA' SIZE 2M
EXTENT MANAGEMENT LOCAL
MAXDATAFILES 100
DATAFILE 'E:\OraData\TEST\SYS1TEST.ORA' SIZE 50 M
DEFAULT TEMPORARY TABLESPACE temp TEMPFILE 'E:\OraData\TEST\TEMP.ORA' SIZE 50 M
UNDO TABLESPACE undo DATAFILE 'E:\OraData\TEST\UNDO.ORA' SIZE 50 M
NOARCHIVELOG
CHARACTER SET WE8ISO8859P1;

Related Commands:

DATABASE - ALTER DATABASE

Related Views:

 GLOBAL_NAME
 DBA_DATA_FILES
 V$CONTROLFILE
 V$DATABASE
 V$DATAFILE
 V$LOG
 V$LOGFILE

Equivalent SQL Server command:

CREATE DATABASE