DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Migration from Oracle 7.3.4 to Oracle 8 using MIG80

  1. #1
    Join Date
    Nov 2000
    Posts
    3

    Question

    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

  2. #2
    Join Date
    Nov 2000
    Posts
    15
    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..."

  3. #3
    Join Date
    Oct 2000
    Posts
    33
    Hi,

    I would go with the 2nd option: create a large rollback segment and put the rest off line.

  4. #4
    Join Date
    Nov 2000
    Posts
    15
    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..."

  5. #5
    Join Date
    Oct 2000
    Posts
    1
    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
  •  


Click Here to Expand Forum to Full Width