|
CREATE DATABASE testdb
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXDATAFILES 100
DATAFILE '/opt/ora9/oradata/testdb/system01.dbf' SIZE 420M REUSE
AUTOEXTEND ON NEXT 1024KB MAXSIZE 32767MB
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE
TEMP TEMPORARY TABLESPACE
TEMP TEMPFILE '/opt/ora9/oradata/testdb/temp01.dbf' SIZE 40MB REUSE
AUTOEXTEND ON NEXT 640KB MAXSIZE 32767MB
UNDO TABLESPACE "UNDOTBS1"
DATAFILE '/opt/ora9/oradata/testdb/undotbs01.dbf' SIZE 200MB REUSE
AUTOEXTEND ON NEXT 5120KB MAXSIZE 32767MB
CHARACTER SET ZHT16BIG5
NATIONAL CHARACTER SET AL16BIG5
LOGFILE GROUP 1 ('/opt/ora9/oradata/testdb/redo01.log') SIZE 102400KB,
GROUP 1 ('/opt/ora9/oradata/testdb/redo02.log') SIZE 102400KB,
GROUP 1 ('/opt/ora9/oradata/testdb/redo03.log') SIZE 102400KB; |
|