ORA-01628: max # extents (505) reached for rollback segment SYSTEM when migrating to Locally managed
I was running the procedure to migrate dictionary managed tablespace to locally managed tablespace using dbms_space_admin.tablespace_migrate_to_local. I worked for all the user tablespaces in the database but one. and I received the following error message:
SQL> EXECUTE dbms_space_admin.tablespace_migrate_to_local ('DATA') ;
BEGIN dbms_space_admin.tablespace_migrate_to_local ('DATA') ; END;
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01562: failed to extend rollback segment number 0
ORA-01628: max # extents (505) reached for rollback segment SYSTEM
ORA-06512: at "SYS.DBMS_SPACE_ADMIN", line 227
ORA-06512: at line 1
I was unable to alter this segment to increase the number of extents or the size of the next extent. I'm not sure why it was using the system rollback segment when the database is set to use the undo tablespace (undo_managemnt = AUTO). I was wondering if anyone else has run into this error. The tablespace is huge with 22 data files.