ORA-01552: cannot use system rollback segment for non-system tablespace 'USERS'错误解决

环境：

oracle10.2.0.1

REDHAT 5.3 64BIT

通过RMAN复制一个新库后，在上面创建表报错

[@more@]

通过RMAN创建一个新实例后在新的实例上进行操作发现报一下错误：

SQL> create table abd (a number);
create table abd (a number)
*
ERROR at line 1:
ORA-01552: cannot use system rollback segment for non-system tablespace 'USERS'

解决方案：

SQL> create rollback segment rbs_seg tablespace system;

Rollback segment created.

SQL> alter rollback segment rbs_seg online;

Rollback segment altered.

SQL> create table test_tran.a(a number);

Table created.

SQL> conn test_tran/test_tran
Connected.
SQL> create table b(a number);

Table created.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@qqdb dump_dir]$ oerr ora 1552
01552, 00000, "cannot use system rollback segment for non-system tablespace '%s'"
// *Cause: Tried to use the system rollback segment for operations involving
// non-system tablespace. If this is a clone database then this will
// happen when attempting any data modification outside of the system
// tablespace. Only the system rollback segment can be online in a
// clone database.
// *Action: Create one or more private/public segment(s), shutdown and then
// startup again. May need to modify the INIT.ORA parameter
// rollback_segments to acquire private rollback segment. If this is
// a clone database being used for tablspace point in time recovery
// then this operation is not allowed. If the non-system tablespace
// has AUTO segment space management, then create an undo tablespace.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10130206/viewspace-1042313/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10130206/viewspace-1042313/