Corrupt Rollback segments - ORA-00600 [4193] [669] [686]
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Corrupt Rollback segments - ORA-00600 [4193] [669] [686]

  1. #1
    Join Date
    Mar 2005
    Posts
    4

    Corrupt Rollback segments - ORA-00600 [4193] [669] [686]

    Hi all,
    When I try to install a build on a linux RH 7.3 system, I receive this ORA-00600 error. Here's the exact error.
    **********************************
    SQL> drop table
    *
    ERROR at line 1:
    ORA-00607: Internal error occurred while making a change to a data block
    ORA-00600: internal error code, arguments: [4193], [669], [686], [], [], [],
    [], []

    **********************************
    I want to know if dropping the rollback segments would do it. Also, how do I know which rollback segment is corrupt? Please help. I am not able to access my main test site. The database (Oracle 9.2) is accessable.

    Thanks in advance.

  2. #2
    Join Date
    Mar 2005
    Posts
    4

    Post

    Did I miss some information that you would like to know or something? Or is this error so unfixable? I don't have a metalink id so I can't use that resource.

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    restore up the point that the error occured

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