Database Administration (MOSC)

MOSC Banner

ORA-01628: max # extents (505) reached for rollback segment SYSTEM when migrating to Locally managed

edited Jun 26, 2014 5:00AM in Database Administration (MOSC) 3 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center