create database with script

hank4ever

CREATE DATABASE TEST
CONTROLFILE REUSE

LOGFILE
GROUP 1 'C:\ORADATA\TEST\REDO01.LOG' SIZE 10M,
GROUP 2 'C:\ORADATA\TEST\REDO02.LOG' SIZE 10M,
GROUP 3 'C:\ORADATA\TEST\REDO03.LOG' SIZE 10M

DATAFILE 'C:\ORADATA\TEST\SYSTEM01.DBF' SIZE 500M
AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL

SYSAUX DATAFILE 'C:\ORADATA\TEST\SYSAUX01.DBF' SIZE 250M
AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL

DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE 'C:\ORADATA\TEST\TEMP01.DBF' SIZE 100M
AUTOEXTEND ON NEXT 100M MAXSIZE 8000M

UNDO TABLESPACE undo
DATAFILE 'C:\ORADATA\TEST\undo01.DBF' SIZE 500M
AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL

CHARACTER SET WE8MSWIN1252

NATIONAL CHARACTER SET AL16UTF16

USER SYS IDENTIFIED BY SOUPERSEEKRET
USER SYSTEM IDENTIFIED BY MYSEEKRET
;