Oracle Manual Database Creation Script in Linux

CREATE DATABASE SAMPLEDB

    USER SYS IDENTIFIED BY YourPassword

    USER SYSTEM IDENTIFIED BY YourPassword

   LOGFILE       GROUP 1 ('/your/local/path/redo01a.log','/your/local/path/redo01b.log') SIZE 100M BLOCKSIZE 512,

              GROUP 2 ('/your/local/path/redo02a.log','/your/local/path/redo02b.log') SIZE 100M BLOCKSIZE 512,

              GROUP 3 ('/your/local/path/redo03a.log','/your/local/path/redo03b.log') SIZE 100M BLOCKSIZE 512

       ARCHIVELOG

      CHARACTER SET AL32UTF8

   NATIONAL CHARACTER SET AL16UTF16

      EXTENT MANAGEMENT LOCAL

   DATAFILE '/your/local/path/system01.dbf' SIZE 325M REUSE

   SYSAUX DATAFILE '/your/local/path/sysaux01.dbf' SIZE 325M REUSE

      DEFAULT TABLESPACE users

         DATAFILE '/your/local/path/users01.dbf'

      SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

   DEFAULT TEMPORARY TABLESPACE temp

      TEMPFILE '/your/local/path/temp01.dbf'

      SIZE 20M REUSE

   UNDO TABLESPACE UNDOTBS1

      DATAFILE '/your/local/path/undotbs01.dbf'

          SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

/