CREATE DATABASE test
LOGFILE group 1 ('/u01/oradata/test/redolog1a.dbf',
'/u02/oradata/test/redolog1b.dbf' ) SIZE 10M,
group 2 ('/u01/oradata/test/redolog2a.dbf',
'/u02/oradata/test/redolog2b.dbf' ) SIZE 10M,
group 3 ('/u01/oradata/test/redolog3a.dbf',
'/u02/oradata/test/redolog3b.dbf' ) SIZE 10M
DATAFILE '/u02/oradata/test/system01.dbf' SIZE 400M autoextend on next 16M maxsize unlimited
CHARACTER SET WE8ISO8859P1
national character set utf8
EXTENT MANAGEMENT LOCAL
sysaux datafile '/u02/oradata/test/sysaux01.dbf' size 300M autoextend on next 16M maxsize unlimited
undo tablespace ts_undo
datafile '/u02/oradata/test/undo01.dbf' size 50M autoextend on next 16M maxsize unlimited
default temporary tablespace ts_temp
tempfile '/u02/oradata/test/temp01.dbf' size 50M autoextend on next 50M maxsize 300M
/