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 to first create and activate a non-system rollback segment in the SYSTEM tablespace. Copyright (C) 1998, Oracle Corporation
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 to first create and activate a non-system rollback segment in the SYSTEM tablespace. Copyright (C) 1998, Oracle Corporation
解决方案 »
- oracle统计重复列的个数
- Oracle如何选择记录的优先级
- Oracle客户端的enterprise manager console登陆闪一下就关闭
- 什么是向前回滚?在哪些情况下需要向前回滚
- 如何取出oracle中某个表的数据结构,也就是所有列名,并放到一个dataset or datatable中?
- linux下启动oracle不成功.请帮忙看看
- 基础问题送分
- oracle805 & win2000server下导入数据,错误提示sql*loader524急急急急急急急
- 怎样在VC中利用ADO访问oracle 8i的BLOB类型?(急!!!)
- 大虾快来,SOS急救,
- 数据库连接不上,请大虾指教!!!
- 急问: rman中的命令report总出错(ora-01843无效的月份)
你能不能说清楚一些,因为我对回滚段,不是太了解,麻烦你先帮我解决这个问题,之后我在学习!真的很谢谢您!
我在创建会滚段时,回报错rsb.dbf 不能用,我在dba studio 看到它是脱机
然后我把他联机,就回报错:需要媒体恢复。我该怎么做,请指导!