16 Mayıs 2013 Perşembe

[EN] ORA-00600: internal error code, arguments: [kcfrbd_3], [239], [3652081], [1], [2949120], [2949120], [], []

ERROR:

SQL> alter table INFRA.TBL_XXX drop partition PART_25;
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcfrbd_3], [239], [3652081], [1], [2949120], [2949120], [], []

SOLUTION:

If the datafile with number 239 belong to the active UNDO tablespace, then try to reduce the size of this datafile. And then increase to its original size if you like. If you can not  reduce the size of this datafile; then create a new UNDO tablespace, switch to this new UNDO tbalespace and then drop the old one.
This should fix the problem.

If not; as a workaround you can first move and then drop the partition.

[EN] ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []

ERROR:

SQL> alter table INFRA.TABLEXXX split partition PART15 at (7030081) into (partition PART16 tablespace TBS_XXX, partition  PART15);
ERROR at line 1:
ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []

SOLUTION:
alter session set events '14525 trace name context forever, level 1';
SQL> alter table INFRA.TABLEXXX split partition PART15 at (7030081) into (partition PART16 tablespace TBS_XXX, partition  PART15);