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

advertisements

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
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.

_____________________________________________________________________________________________________________________

Website Stats

0 comments:

Post a Comment

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer