ORA01552 cannot use system rollback segment for nonsystem tablespace
Anyone know how to make use of system tablespace? I realized that all my processes always refer to the same system tablespace where I did created more than 1. Besides, is anyone know what the purpose of specify the content in the tablespace like "Any Data", "user Temporary Data", and "system Temporary Data".
by toms1981 - DB2 - 2005-05-16 15:57:47 阅读（1044） 回复（2）
ora_01552错,非系统表空间'zhengguan'无法使用系统回滚段? 谁能帮忙解决? 在做SQL查询时报的错,创建表的语句如下: create table PTF_VERSION ( PTF_NAME VARCHAR2(10) not null, VERSION_NUM NUMBER(4), VERSION_MODIFY DATE, VERSION_REMARK VARCHAR2(400) ) tablespace ZHENGGUAN pctfree 10 initrans 1 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); 会有...
数据库open时提示rollback segment不可用，然后数据库就吊在那里启动不了。这时我想create rollback segment或drop rollback segment，提示oracle不可用。这时怎么办？在mount状态下可以建或删回滚段吗？
error ocurr when I create rollback segment ,information is following: SQL>; l 1 create rollback segment emprbs 2 tablespace emp 3* storage(initial 250k next 250k minextents 2 optimal 1M) SQL>; / create rollback segment emprbs * ERROR at line 1: ora-30019: Illegal rollback segment operation in Automatic Undo mode SQL>;
when I create database with dbca,there are following tablespace which I don't know : DRSYS,TOOLS,XDB?
环境： oracle 7.3.4 aix 4.3.1 问题： 我们的数据库的rollback segment损坏（corrupted)，从而导致数据库无法正常访问。影响生产，目前处于巨大压力之下。。。。。。 哪位大侠伸出援助之手，不胜感激！ ！！
创建表时有这样的错误的提示：unable to create INITIAL extent for segment in tablespace MYTAB，是不是表空间不够，怎么查看这个表空间的情况？
SQL> CREATE TEMPoraRY tablespace TEMP TEMPFILE 2 '/u10/ocaca/oradata/temp01.dbf' SIZE 300M AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED 3 tablespace GROUP '' 4 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M; CREATE TEMPoraRY tablespace TEMP TEMPFILE * ERROR at line 1: ora-01543: tablespace 'TEMP' already exists SQL> drop tablespace temp; drop tablespace temp * ERROR at line 1: ora-12906: canno...
1)rollback segment 除了存放旧数据（before image）, 但永远不会存放新数据(new value )? 2)rollback segment 什么时候释放？在commit 后？ 谢谢
