Move Subpartition for an Interval Partitioned Table Failed: ORA-00600 [kkpod nextFrag]

Error Description:
Alter table move subpartition on an interval partitioned table is failed with following error. Also the session got disconnected.


SQL> alter table SCOTT.TEST_PART move SUBpartition SYS_SUBP1906269 lob(PART_COL) store as (tablespace users);
alter table SCOTT.TEST_PART move SUBpartition SYS_SUBP1906269 lob(PART_COL) store as (tablespace users)
                    *
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [kkpod nextFrag], [1], [2], [1], [1], [218194], [], [], [], [], [], []
Process ID: 10599
Session ID: 7 Serial number: 12180
Solution Description:
As per metalink support it is bug and patch has been released for the same in Oracle 11.2.0.2.
Bug 12325317
Patch for 11.2.0.2 : 12325317
It has been resolved in 11.2.0.3.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google