Created
August 29, 2017 04:24
-
-
Save shashank-ssriva/5dfe76c1133980ebc31ea8e5ae1223de to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE DATABASE XE | |
USER SYS IDENTIFIED BY system123 | |
USER SYSTEM IDENTIFIED BY system123 | |
controlfile reuse | |
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/XE/redo01.log') SIZE 100M, | |
GROUP 2 ('/u01/app/oracle/oradata/XE/redo02.log') SIZE 100M, | |
GROUP 3 ('/u01/app/oracle/oradata/XE/redo03.log') SIZE 100M | |
MAXLOGFILES 5 | |
MAXLOGMEMBERS 5 | |
MAXLOGHISTORY 1 | |
MAXDATAFILES 100 | |
CHARACTER SET US7ASCII | |
NATIONAL CHARACTER SET AL16UTF16 | |
EXTENT MANAGEMENT LOCAL | |
DATAFILE '/u01/app/oracle/oradata/XE/system01.dbf' SIZE 325M REUSE | |
SYSAUX DATAFILE '/u01/app/oracle/oradata/XE/sysaux01.dbf' SIZE 325M REUSE | |
DEFAULT TABLESPACE users | |
DATAFILE '/u01/app/oracle/oradata/XE/users01.dbf' | |
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED | |
DEFAULT TEMPORARY TABLESPACE tempts1 | |
TEMPFILE '/u01/app/oracle/oradata/XE/temp01.dbf' | |
SIZE 20M REUSE | |
UNDO TABLESPACE UNDOTBS1 | |
DATAFILE '/u01/app/oracle/oradata/XE/undotbs01.dbf' | |
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Simple Oracle script to create a database. Replace values with your own.
Please ensure that
/u01/app/oracle/oradata/XE
or a similar directory is already created before you execute this script.