5 Replies Latest reply: Jan 25, 2013 3:37 PM by Osama_Mustafa RSS

    ora-00600 error when dropping a table

    987221
      Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

      When I tried to drop a table, I got 600 error:

      SQL> desc DEV.ATTR_IDX$EX
      Name Null? Type
      ----------------------------------------- -------- ----------------------------
      NODE_ID NOT NULL NUMBER
      COL1 NUMBER

      SQL> show user;
      USER is "DEV"
      SQL> select count(*) from DEV.ATTR_IDX$EX;

      COUNT(*)
      ----------
      0

      SQL> drop table DEV.ATTR_IDX$EX;
      drop table DEV.ATTR_IDX$EX
      *
      ERROR at line 1:
      ORA-00600: internal error code, arguments: [15265], [], [], [], [], [], [], [],
      [], [], [], []


      SQL> drop table DEV.ATTR_IDX$EX purge;
      drop table DEV.ATTR_IDX$EX purge
      *
      ERROR at line 1:
      ORA-00600: internal error code, arguments: [15265], [], [], [], [], [], [], [],
      [], [], [], []

      I guess this is because it had a parent table, which I dropped (I used "drop table <parent_table>", and it did not give me error, very strange).

      SQL> select dbms_metadata.get_ddl('TABLE','ATTR_IDX$EX') from dual;

      DBMS_METADATA.GET_DDL('TABLE','ATTR_IDX$EX')
      --------------------------------------------------------------------------------

      CREATE TABLE "DEV"."ATTR_IDX$EX"
      ( "NODE_ID" NUMBER NOT NULL ENABLE,
      "COL1" NUMBER,
      FOREIGN KEY ("NODE_ID")
      REFERENCES () ON DELETE CASCADE ENABLE
      ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
      STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
      PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
      TABLESPACE "USERS"
      MONITORING

      Try to drop FK constraints yields the same error.
      So now how can I drop this table table, any work around?
      Thanks.