Database Administration (MOSC)

MOSC Banner

ORA-01628: max # extents (505) reached for rollback segment RB16

edited Mar 6, 2014 10:57AM in Database Administration (MOSC) 4 commentsAnswered ✓

Hi all,

on 8i, on Win2003 , importin a full database I received :

. . importing table           "PS_CE_ITEMCOST"

IMP-00058: ORACLE error 1562 encountered

ORA-01562: failed to extend rollback segment number 17

ORA-01628: max # extents (505) reached for rollback segment RB16

Then I changed maxextent for RBS16 and IMP continued like this :

IMP-00028: partial import of previous table rolled back: 39809589 rows rolled ba

ck

. . importing table       "PS_CE_ITEMCOST_ARC"6705254 rows imported

Should I re importe the PS_CE_ITEMCOST table ?

Thank you.

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