Wednesday, April 16, 2008

ORA-30014:

File "create_db_orcl3.sql" contain:

CREATE DATABASE orcl3
   USER SYS IDENTIFIED BY oracle
   USER SYSTEM IDENTIFIED BY oracle
   LOGFILE GROUP 1 ('/oracle/oracle_home/orcl3_data/orcl3/redo01.log') SIZE 100M,
           GROUP 2 ('/oracle/oracle_home/orcl3_data/orcl3/redo02.log') SIZE 100M,
           GROUP 3 ('/oracle/oracle_home/orcl3_data/orcl3/redo03.log') SIZE 100M
   MAXLOGFILES 5
   MAXLOGMEMBERS 5
   MAXLOGHISTORY 1
   MAXDATAFILES 100
   MAXINSTANCES 1
   CHARACTER SET US7ASCII
   NATIONAL CHARACTER SET AL16UTF16
   DATAFILE '/oracle/oracle_home/orcl3_data/orcl3/system01.dbf' SIZE 325M REUSE
   EXTENT MANAGEMENT LOCAL
   SYSAUX DATAFILE '/oracle/oracle_home/orcl3_data/orcl3/sysaux01.dbf' SIZE 325M REUSE
   DEFAULT TABLESPACE tbs_1
   DEFAULT TEMPORARY TABLESPACE tempts1
      TEMPFILE '/oracle/oracle_home/orcl3_data/orcl3/temp01.dbf'
      SIZE 20M REUSE
   UNDO TABLESPACE undotbs
      DATAFILE '/oracle/oracle_home/orcl3_data/orcl3/undotbs01.dbf'
      SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

===========================================================

SQL> startup nomount;
ORACLE instance started.

Total System Global Area  171966464 bytes
Fixed Size                  2004832 bytes
Variable Size             150997152 bytes
Database Buffers           16777216 bytes
Redo Buffers                2187264 bytes
SQL> @create_db_orcl3.sql
CREATE DATABASE orcl3
*
ERROR at line 1:
ORA-30014: operation only supported in Automatic Undo Management mode

No comments:

Post a Comment