-
Hi,
We are trying to migrate from Oracle 7.3.4 to Oracle 8 using MIG80 utility.
Used MIG80 with the space check and created enough space for the system table space.
Later on running MIG80 resulted in the following error:
ORA-01562: failed to extend rollback segment number 0
ORA-01628: max # extents (2) reached for rollback segment SYSTEM
To solve this we increased the value of MAX_EXTENTS to 500 for the System Rollback segment. (Confirmed by the following select:
SELECT MAX_EXTENT FROM DBA_ROLLBACK_SEGS
WHERE SEGMENT_NAME = 'SYSTEM';
still it ended up with the same error. Please suggest a solution.
Thanks in advance,
Ratheesh
-
Hello,
Please try creating another rollback segment for your SYSTEM tablespace. I guess it is only using the rollback segment created by ORACLE which is the SYSTEM ROLLBACK SEGMENT. Sometimes it is not enough that is why you have to create another one. Be sure to enable your ROLLBACK SEGMENT. You could use this one and in case it still didn't work just let me know...
You could create a large rollback segment for this one since you could drop it or make it offline after you finish your migration.
Good Luck!!!
Cardinal
-
Hi,
I would go with the 2nd option: create a large rollback segment and put the rest off line.
-
hello,
Remember that you cannot take your SYSTEM ROLLBACK SEGMENT OFFLINE. Also, you must not forget that your rollback segments are offline by default and you have to manually take that online or enable that in your INIT.ORA.
cardinal
-
Try to increase the size of next extent and it wouldn't eat all the extents.