OracleDB‎ > ‎

Manual DB Creation

create_db.sql

create database test_db1
user sys identified by p4ssw0rd
user system identified by p4ssw0rd
maxinstances 1
maxloghistory 1
maxlogfiles 5
maxlogmembers 5
character set US7ASCII
national character set AL16UTF16
datafile '/u02/oradata/test_db1/system01.dbf' size 500M
extent management LOCAL
SYSAUX datafile '/u02/oradata/test_db1/sysaux01.dbf' size 500M
DEFAULT TEMPORARY tablespace temp01
tempfile '/u02/oradata/test_db1/temp01_01.dbf' size 100M
UNDO tablespace undotbs_01
datafile '/u02/oradata/test_db1/undotbs01.dbf' size 200M
DEFAULT tablespace users
datafile '/u02/oradata/test_db1/users01.dbf' size 100M
LOGFILE group 1
('/u02/oradata/test_db1/redo01.log') size 100M,
group 2
('/u01/app/oracle/oradata/test_db1/redo02.log') size 100M;

Comments