CREATE DATABASE SCRIPT - Sample

 

CREATE DATABASE mydb

   USER SYS IDENTIFIED BY password

   USER SYSTEM IDENTIFIED BY password

   LOGFILE

GROUP 1 ('/u01/oracle/oradata/mydb/redo01.log') SIZE 100M,

GROUP 2 ('/u01/oracle/oradata/mydb/redo02.log') SIZE 100M,

GROUP 3 ('/u01/oracle/oradata/mydb/redo03.log') SIZE 100M

   MAXLOGFILES 5

   MAXLOGMEMBERS 5

   MAXLOGHISTORY 1

   MAXDATAFILES 100

   MAXINSTANCES 1

   CHARACTER SET US7ASCII

   NATIONAL CHARACTER SET AL16UTF16

   DATAFILE '/u01/oracle/oradata/mydb/system01.dbf' SIZE 325M

                                                                                                REUSE

   EXTENT MANAGEMENT LOCAL

   SYSAUX DATAFILE '/u01/oracle/oradata/mydb/sysaux01.dbf' SIZE

                                                                                       325M REUSE

   DEFAULT TABLESPACE users

   DATAFILE '/u01/app/oracle/oradata/mydb/users.dbf' SIZE 500M

   DEFAULT TEMPORARY TABLESPACE tempts1

      TEMPFILE '/u01/oracle/oradata/mydb/temp01.dbf'

      SIZE 20M REUSE

   UNDO TABLESPACE undotbs

      DATAFILE '/u01/oracle/oradata/mydb/undotbs01.dbf'

      SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;