Skip to content

Instantly share code, notes, and snippets.

@shashank-ssriva
Created August 29, 2017 04:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save shashank-ssriva/5dfe76c1133980ebc31ea8e5ae1223de to your computer and use it in GitHub Desktop.
Save shashank-ssriva/5dfe76c1133980ebc31ea8e5ae1223de to your computer and use it in GitHub Desktop.
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;
@shashank-ssriva
Copy link
Author

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment