oracle求助 - 未名空间MITBBS历史存档

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

Redian新闻

>未名空间

>Database - 数据库

oracle求助

oracle求助# Database - 数据库

s*e2000-03-02 08:03

1 楼

i am now using the oracle database,
and i happen to meet this question,
who can solve it!
the error is :
cannot use system rollback segment for non-system tablespace 'USERS'

j*s2000-03-02 08:03

2 楼

ORA-01552: cannot use system rollback segment for non-system
tablespace [name]
Cause: An attempt was made to use the SYSTEM rollback segment for
operations
involving a non-system tablespace.
Action: Create one or more rollback segments and then use ALTER
ROLLBACK
SEGMENT ’name’ online. It may be necessary to modify the
initialization
parameter ROLLBACK_SEGMENTS to acquire one of the new private
rollback segments. Before creating a rollback segment outside the
SYSTEM
tablespace, it is necessary t

【在 s******e 的大作中提到】

: i am now using the oracle database,
: and i happen to meet this question,
: who can solve it!
: the error is :
: cannot use system rollback segment for non-system tablespace 'USERS'