question on create a db manually - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

question on create a db manually

question on create a db manually# Database - 数据库

l*r2003-06-04 07:06

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*s2003-06-04 07:06

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',