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

Related Commands:

DATABASE - ALTER DATABASE

Related Views:

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




Back to the Top

Simon Sheppard
SS64.com