Results 1 to 8 of 8

Thread: Ora-00600

  1. #1
    Join Date
    Jan 2003
    Posts
    5

    Unhappy Unanswered: Ora-00600

    We are trying to drop a table in Oracle7.3.3.4.0 but get the following error :

    ORA-00600: internal error code, arguments: [16515], [D], [2], [82097], [8], [0], [], []


    We have tried dropping the user with the cascade option and the tablespace including contents but get the same error when it reaches this table


    Any ideas (apart from rebuilding the instance)?

  2. #2
    Join Date
    Aug 2002
    Location
    IL
    Posts
    73

    Re: Ora-00600

    Originally posted by semo
    We are trying to drop a table in Oracle7.3.3.4.0 but get the following error :

    ORA-00600: internal error code, arguments: [16515], [D], [2], [82097], [8], [0], [], []


    We have tried dropping the user with the cascade option and the tablespace including contents but get the same error when it reaches this table


    Any ideas (apart from rebuilding the instance)?
    Did you try rebuilding the table ?

  3. #3
    Join Date
    Jan 2003
    Posts
    5
    We have tried everything we can think of. We can rename the table, we can copy the table, we can export the table and re-import it into another schema and another instance. We just cannot drop the original table, nor analyze it.

  4. #4
    Join Date
    Aug 2002
    Location
    IL
    Posts
    73
    Originally posted by semo
    We have tried everything we can think of. We can rename the table, we can copy the table, we can export the table and re-import it into another schema and another instance. We just cannot drop the original table, nor analyze it.
    Your problem is the actual table, you should create a new one, copy all data, drop old, rename new to be as the old one's name. If you can not so that becuae you need this table 24x7, then try rebuilding all indexes of the table (use rebuild online - for the 24x7).

    Tal.

  5. #5
    Join Date
    Jan 2003
    Posts
    5
    The table is empty and has no indexes. We don't need the table as we have already copied it and the new one is the LIVE version. We are not able to drop the old table as we get ORA-00600 when we try. We want to drop this old table but are unable to

  6. #6
    Join Date
    Jan 2003
    Location
    Kolkata, India
    Posts
    4
    just
    Set SORT_AREA_RETAINED_SIZE to the same value as SORT_AREA_SIZE,
    or
    Do not set SORT_AREA_RETAINED_SIZE to any value

  7. #7
    Join Date
    Sep 2002
    Location
    Ohio
    Posts
    204
    This is going back a few years, but I can recall running into a similar problem in a 7.3.3.4 database. In our case there was a data dictionary corruption that prevented us from dropping the table.

    We had to work with Oracle Support to do some 'undocumented, only do at the request of Oracle Support' stuff. If you have support, I'd advise using it. If not, does the mere existance of the table cause any problems? If it is the same problem we had and you can't get support from Oracle, it might be safest to leave it as is.

    HTH,
    Patrick

    Originally posted by semo
    The table is empty and has no indexes. We don't need the table as we have already copied it and the new one is the LIVE version. We are not able to drop the old table as we get ORA-00600 when we try. We want to drop this old table but are unable to

  8. #8
    Join Date
    Jan 2003
    Posts
    5

    Smile

    Thank you Patrick
    I've fixed the problem by truncating sys.hist_head$ which had a lot of rows for this table

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •