ORA-01552: non-system tablespace USERS cannot use system rollback segment Processing

ERROR: CallableStatementCallback; uncategorizedSQLExceptionforSQL [{callUSP_SYS_CMSCODE (?,?,?)}]; SQLstat

ERROR: CallableStatementCallback; uncategorizedSQLExceptionforSQL [{callUSP_SYS_CMSCODE (?,?,?)}]; SQLstat

Fault symptom:

ERROR: 12-09-20 16:15:03 get the maximum size ERROR: CallableStatementCallback; uncategorized SQLException for SQL [{call USP_SYS_CMSCODE (?, ?, ?, ?)}]; SQL state [72000]; error code [1552]; ORA-01552: non-system tablespace 'users' cannot use system rollback segments

ORA-06512: In "WMP2.USP _ SYS_CMSCODE", line 24

ORA-06512: In "WMP2.USP _ SYS_CMSCODE", line 31

ORA-06512: In line 1; nested exception is java. SQL. SQLException: ORA-01552: non-system tablespace 'users' cannot use system rollback segments

ORA-06512: In "WMP2.USP _ SYS_CMSCODE", line 24

ORA-06512: In "WMP2.USP _ SYS_CMSCODE", line 31

ORA-06512: In line 1

Java. lang. RuntimeException: CallableStatementCallback; uncategorized SQLException for SQL [{call USP_SYS_CMSCODE (?, ?, ?, ?)}]; SQL state [72000]; error code [1552]; ORA-01552: non-system tablespace 'users' cannot use system rollback segments

ORA-06512: In "WMP2.USP _ SYS_CMSCODE", line 24

ORA-06512: In "WMP2.USP _ SYS_CMSCODE", line 31

ORA-06512: In line 1

; Nested exception is java. SQL. SQLException: ORA-01552: non-system tablespace 'users' cannot use system rollback segments

ORA-06512: In "WMP2.USP _ SYS_CMSCODE", line 24

ORA-06512: In "WMP2.USP _ SYS_CMSCODE", line 31

ORA-06512: In line 1

Fault analysis:

The UNDO tablespace data file is damaged and the Hong Kong VM fails to perform the update operation.

Fault repair:

C: \ Documents ents and Settings \ Administrator> sqlplus/as sysdba

SQL * Plus: Release 10.2.0.1.0-Production on Thursday September 20 17:26:38 2012

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Connect:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production

With the Partitioning, OLAP and Data Mining options

SQL> create undo tablespace "UNDOTBS02" datafile 'd: \ oracle \ product \ 10.2.0 \ oradata \ zjport \ undotbs02.dbf' size 128 m reuse autoextend on next 10 m maxsize 2048 m;

The tablespace has been created.

SQL> alter system set undo_tablespace = UNDOTBS02 scope = spfile;

The system has been changed.

SQL> alter system set undo_management = auto scope = spfile;

The system has been changed.

SQL> shutdown immediate;

The database has been closed.

The database has been detached.

The ORACLE routine has been disabled.

SQL> startup;

The ORACLE routine has been started.

The database has been loaded.

The database has been opened.

SQL> DROP TABLESPACE UNDOTBS1 INCLUDING CONTENTS AND DATAFILES;

The tablespace has been deleted.

SQL> shutdown immediate;

The database has been closed.

The database has been detached.

The ORACLE routine has been disabled.

SQL> startup;

The ORACLE routine has been started.

Total System Global Area 612368384 bytes

Fixed Size 1250428 bytes

Variable Size 167775108 bytes

Database Buffers 436207616 bytes

Redo Buffers 7135232 bytes

The database has been loaded.

The database has been opened.

This article is from the "wheat dock" blog, American servers, and virtual hosts. Be sure to keep this source