-
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
Thanks,
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
"Let's get it on..."
-
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<sid_name>.ORA.
cardinal
"Let's get it on..."
-
Try to increase the size of next extent and it wouldn't eat all the extents.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|