ORA-01552: 非系统表空间'TEST_DATA'无法使用系统回退段

ORA-1552 cannot use system rollback segment for non-system tablespace

?

?

解决
=========
在system表空间或者其他字典管理表空间创建一个回滚段

? ?SQL> CREATE ROLLBACK SEGMENT rbs_dummy
? ???2??TABLESPACE system
? ???3??STORAGE (INITIAL 10k NEXT 10k MINEXTENTS 2);
? ?
? ?Rollback segment created.

? ?SQL> ALTER ROLLBACK SEGMENT rbs_dummy ONLINE;

? ?Rollback segment altered.

? ?SQL> CREATE ROLLBACK SEGMENT rbs0
? ???2??TABLESPACE local_rbs
? ???3??STORAGE (INITIAL 100k NEXT 100k MINEXTENTS 2);

? ?Rollback segment created.

? ?SQL> ALTER ROLLBACK SEGMENT rbs0 ONLINE;

? ?Rollback segment altered.

?

创建一个新的undo表空间，修改数据库将undo_tablespace指向新的undo表空间

?

?

?

create undo tablespace UNDO_TBS1
datafile 'C:\oracle\oradata\ora9i\undotbs01.dbf'
size 200m

在创建表空间后，先关闭数据库，再把UNDO_TABLESAPCE参数添加到初始化参数文件里。这几项是这样的
undo_management='AUTO'
undo_tablespace='UNDO_TBS1'
=======================

SQL>alter system set undo_tablespace=UNDO_YJ scope=both;

最后重起库就可以啦