Creating Database

To create a database, use the following SQL command :

CREATE DATABASE [database]
 [CONTROLFILE REUSE]
 [LOGFILE [GROUP integer] filespec
 [MAXLOGFILES integer]
 [MAXLOGMEMBERS integer]
 [MAXLOGHISTORY integer]
 [MAXDATAFILES integer]
 [MAXINSTACES integer]
 [ARCHIVELOG |NOARCHIVELOG]
 [CHARACTER SET charset]
 [NATIONAL CHARACTER SET charset]
[DATAFILES filespec [autoextend_clause]
filespec :== 'filename' [SIZE integer] [K|M] [REUSE]
 autoextend_clause :==
 [AUTOEXTEND {OFF | ON [NEXT integer [K|M] ] [MAXSIZE {UNLIMMITED | integer [K|M] } } ]
[DEFAULT TEMPORARY TABLESPACE tablespace filespec [temp_tablespace_extend_clause]
temp_tablespace_extend_clause :==
EXTENT MANAGEMENT LOCAL UNIFORM [SIZE integer] [K|M] ]

[UNDO TABLESPACE tablespace DATAFILE filespec [autoextend_clause] ]
[SET TIME_ZONE [time_zone_region] ]

Example:
CREATE DATABASE userdb
 LOGFILE
  GROUP 1 ('/$HOME/ORADATA/u01/redo1.log') SIZE 100M,
  GROUP 2 ('/$HOME/ORADATA/u02/redo1.log') SIZE 100M,
   GROUP 3 ('/$HOME/ORADATA/u03/redo1.log') SIZE 100M
 MAXLOGFILES 5
 MAXLOGMEMBERS 5
 MAXLOGHISTORY 1
 MAXDATAFILES 100
 MAXINSTANCES 1
 DATAFILE '/$HOME/ORADATA/u01/system01.dbf' SIZE 300M
 UNDO TABLESPACE undotbs
 DATAFILE '/$HOME/ORADATA/u02/undotbs01.dbf' SIZE 300M
  AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
 DEFAULT TEMPORARY TABLESPACE temp
 CHARACTER SET US7ASCII
 NATIONAL CHARACTER SET AL16UTF16
 SET TIME_ZONE = 'America/New_York'