ORA-01552 non-system tablespace cannot be processed using system rollback segments

ORA-01552 non-system tablespace cannot use system rollback segments to handle ORA-01552: cannot use system rollback segment... troubleshooting error: the database is not completely restored today, but several tables need to be created as the base table for recovery when preparing the environment. When creating a table, www.2cto.com reports the following error: 13: 56: 03 SQL> create table wwl001 (id number, name varchar (12 )); create table wwl001 (id number, name varchar (12) * ERROR at line 1: ORA-01552: cannot use system rollback segment for non-system tablespace 'wwl ';!!!! The non-system tablespace 'wwl' cannot use the system rollback segment. Cause: I made a database disaster recovery yesterday due to disk damage, probably because the parameter file was modified during recovery, therefore, the rollback segment is changed to the manual management mode. Let's take a look at the following steps: Details: 1. Create a table, non-system tablespace cannot use rollback segments 13:56:03 SQL> create table wwl001 (id number, name varchar (12); create table wwl001 (id number, name varchar (12 )) * ERROR at line 1: ORA-01552: cannot use system rollback segment for non-system tablespace 'wwl'; 2. view the rollback segment management method, for manual management of 13:57:24 SQL> show parameter undoNAME TYPE VALUE =----------- ------------------------------ undo_management string MANUALundo_retention integer 900undo_tablespace string UNDOTBS1
3. Check the rollback segment status www.2cto.com 13:57:23 SQL> select segment_name, tablespace_name, status from dba_rollback_segs; SEGMENT_NAME TABLESPACE_NAME STATUS when loading SYSTEM variable $ UNDOTBS1 variable $ UNDOTBS1 variable $ UNDOTBS1 variable $ specified variable $ UNDOTBS1 variable $ UNDOTBS1 variable $ UNDOTBS1 variable $ UNDOTBS1 parameter $ UNDOTBS1 OFFLINE11 rows selected.
4. Modify the undo_management parameter to auto. 14:08:06 SQL> alter system set undo_management = auto scope = spfile; System altered.14: 17: 51 SQL> shutdown immediateDatabase closed. database dismounted. ORACLE instance shut down.14: 18: 22 SQL> startupORACLE instance started. total System Global Area 100663296 bytesFixed Size 1217884 bytesVariable Size 88083108 bytesDatabase Buffers 8388608 bytesRedo Buffers 2973696 bytesDatabase mounted. www.2cto.com Database opened.
5. View rollback segment status 14:18:55 SQL> select segment_name, tablespace_name, status from dba_rollback_segs; SEGMENT_NAME TABLESPACE_NAME STATUS when starting ---------------- SYSTEM region $ UNDOTBS1 region $ UNDOTBS1 region $ UNDOTBS1 region $ UNDOTBS1 region $ UNDOTBS1 region $ UNDOTBS1 region $ UNDOTBS1 ONLINE_S YSSMU8 $ UNDOTBS1 ONLINE_SYSSMU9 $ UNDOTBS1 ONLINE_SYSSMU10 $ UNDOTBS1 ONLINE11 rows selected.6. We can execute the table creation statement just now. At 14:19:51 SQL> create table wwl001 (id number, name varchar (12); Table created. Author wuweilong