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.