由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - oracle求助
相关主题
How to creat user in Oracle?刚做了70-433一道题,觉得答案有问题
怎么设置多个用户 (Oracle 10g)?tablespace是个啥样的概念啊?
Oracle database link problemOracle 8i export and import ?
出道oracle dba 面试题oracle里有些怪怪的表,不只是哪里来的?
问个关于Oracle recyclebin的菜鸟问题how to know how many uses exists in my db?
求救,这个更新如何写?create database 在oracle中有什么用处?
oracle dbca help?question: how to drop a tablespace
安装Sybase ASE15 Linux Express版失败,请教了Help: 如何在oracle 9i 中添加1 个user?
相关话题的讨论汇总
话题: rollback话题: system话题: segment话题: tablespace话题: oracle
进入Database版参与讨论
1 (共1页)
s******e
发帖数: 19
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****s
发帖数: 271
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'

1 (共1页)
进入Database版参与讨论
相关主题
Help: 如何在oracle 9i 中添加1 个user?问个关于Oracle recyclebin的菜鸟问题
[转载] question on SQL求救,这个更新如何写?
Export Oracle db schema onlyoracle dbca help?
问个RMAN问题安装Sybase ASE15 Linux Express版失败,请教了
How to creat user in Oracle?刚做了70-433一道题,觉得答案有问题
怎么设置多个用户 (Oracle 10g)?tablespace是个啥样的概念啊?
Oracle database link problemOracle 8i export and import ?
出道oracle dba 面试题oracle里有些怪怪的表,不只是哪里来的?
相关话题的讨论汇总
话题: rollback话题: system话题: segment话题: tablespace话题: oracle