CREATE DATABASE

Create a database.

Syntax:

   CREATE DATABASE database_name options

options can be any combination of the following:

   DATAFILE filespec AUTOEXTEND OFF
   DATAFILE filespec AUTOEXTEND ON [NEXT int K | M] [MAXSIZE int K | M]
   LOGFILE [GROUP int] filespec
   MAXDATAFILES int
   MAXLOGFILES int
   MAXLOGMEMBERS int
   MAXLOGHISTORY int
   MAXINSTANCES int
   CONTROLFILE REUSE
   CHARACTER SET charset

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

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

CREATE DATABASE TEST
LOGFILE 'E:\Oracle\TEST\LOGS\LOG1TEST.ORA' SIZE 2M,
'E:\Oracle\TEST\LOGS\LOG2TEST.ORA' SIZE 2M,
'E:\Oracle\TEST\LOGS\LOG3TEST.ORA' SIZE 2M,
'E:\Oracle\TEST\LOGS\LOG4TEST.ORA' SIZE 2M,
'E:\Oracle\TEST\LOGS\LOG5TEST.ORA' SIZE 2M
MAXDATAFILES 100
DATAFILE 'E:\Oracle\TEST\DATA\SYS1TEST.ORA' SIZE 50 M
NOARCHIVELOG
CHARACTER SET WE8ISO8859P1;

create rollback segment rb_temp
tablespace system
storage(initial 50K next 50K minextents 2);

alter rollback segment rb_temp online;

Related Commands:

DATABASE - ALTER DATABASE

Related Views:

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