SQL> CREATE DATABASE TESTDB
2 CONTROLFILE REUSE
3 MAXINSTANCES 32
4 MAXLOGHISTORY 0
5 MAXLOGFILES 192
6 MAXLOGMEMBERS 3
7 MAXDATAFILES 1024
8 DATAFILE '/dev/vx/rdsk/oradg/system01' REUSE AUTOEXTEND ON
NEXT 10240K MAXSIZE UNLIMITED
9 EXTENT MANAGEMENT LOCAL
10 DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE
'/dev/vx/rdsk/oradg/temp01' REUSE AUTOEXTEND ON NEXT 640K
MAXSIZE UNLIMITED
11 UNDO TABLESPACE "UNDOTBS1" DATAFILE
'/dev/vx/rdsk/oradg/undotbs01' REUSE AUTOEXTEND ON NEXT 5120K
MAXSIZE UNLIMITED
12 CHARACTER SET KO16KSC5601
13 NATIONAL CHARACTER SET UTF8
14 LOGFILE GROUP 1 ('/dev/vx/rdsk/oradg/redo01') REUSE,
15 GROUP 2 ('/dev/vx/rdsk/oradg/redo02') REUSE;
EXTENT MANAGEMENT LOCAL
*
ERROR at line 9:
ORA-02165: invalid option for CREATE DATABASE
|