l***r
发帖数: 459 | 1 Greetings,
I met this error when I try to create a database manually:
ERROR at line 1:
ORA-30014: operation only supported in Automatic Undo Management mode
My simple script looks like:
create database SMALL
logfile
group 1 ('/opt/oracle/oradata/SMALL/redo101.log',
'/opt/oracle/oradata/SMALL/redo102.log') SIZE 5M REUSE,
group 2 ('/opt/oracle/oradata/SMALL/redo201.log',
'/opt/oracle/oradata/SMALL/redo202.log') SIZE 5M REUSE
ARCHIVELOG
datafi | s***s
发帖数: 148 | 2 It can be set in your init.ora file.
add a line like the following:
UNDO_MANAGEMENT = AUTO
restart your database, you'll be fine.
【在 l***r 的大作中提到】
: Greetings,
: I met this error when I try to create a database manually:
: ERROR at line 1:
: ORA-30014: operation only supported in Automatic Undo Management mode
: My simple script looks like:
: create database SMALL
: logfile
: group 1 ('/opt/oracle/oradata/SMALL/redo101.log',
: '/opt/oracle/oradata/SMALL/redo102.log') SIZE 5M REUSE,
: group 2 ('/opt/oracle/oradata/SMALL/redo201.log',
|
|
