ORA-00600: [kkpolLS1] Moving LOB Partitions To Another Tablespace (Doc ID 2802443.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

ALTER TABLE <TABLE NAME> move partition SYS_P28935 online parallel 15 LOB(<LOB>) store as (tablespace <tablespace>)
*****************************************************************
DECLARE
*
ERROR at line 1:
ORA-12801: error signaled in parallel query server P007, 
ORA-00600: codigo de erro interno, argumentos: [kkpolLS1], [], [], [], [], [], [], [], [], [], [], []

----- Current SQL Statement for this session (sql_id=cduvbuupb4dby) -----

select fragobj#, indfragobj#, ts#, file#, block#, fragflags, chunk,pctversion$, fragpro from lobfrag$ where parentobj# = :1 order by frag#

[TOC00003-END]

Call Stack

Problem Key: ORA 600 [kkpolLS1]

Error: ORA-600 [kkpolLS1] [] [] [] [] [] [] [] [] [] [] []

[00]: dbgexPopulateIncCtx [diag_dde]

[01]: dbgexProcessError [diag_dde]

[02]: dbgePostErrorKGE [diag_dde]

[03]: dbkePostKGE_kgsf [rdbms_dde]

[04]: kgeadse []

[05]: kgerinv_internal []

[06]: kgerinv []

[07]: kgeasnmierr []

[08]: kkpoflfi_fetch_lob_frag_info [PART]<-- Signaling

[09]: opifcr [OPI]

[10]: qertbFetchByRowID [SQL_Execution]

[11]: opifch2 [OPI]

[12]: opiall0 [OPI]

[13]: opikpr [OPI]

[14]: opiodr [OPI]

[15]: rpidrus [RPI]

[16]: skgmstack []

[17]: rpidru [RPI]

[18]: rpiswu2 [RPI]

[19]: kprball [RPI]

[20]: kkpolld_load_lob_descr [PART]

[21]: kkpolpd_load_part_descr [PART]

[22]: kqlCallback [LIBCACHE]

[23]: kqllod_new [LIBCACHE]

[24]: kqlCallback [LIBCACHE]

[25]: kqllod [LIBCACHE]

[26]: kglobld [LIBCACHE]

[27]: kglobpn [LIBCACHE]

[28]: kglpim [LIBCACHE]

[29]: kkdlgstd []

[30]: kkmfcbloCbk [SQL_Semantic]

[31]: kkmpfcbk [SQL_Semantic]

[32]: qcsprfro [SQL_Parser]

[33]: qcsprfro_tree [SQL_Parser]

[34]: qcsprfro_tree [SQL_Parser]

[35]: qcspafq [SQL_Parser]

[36]: qcspqbDescendents [SQL_Parser]

[37]: qcspqb [SQL_Parser]

[38]: kkmdrv [SQL_Semantic]

[39]: opiSem [OPI]

[40]: opiprs [OPI]

[41]: kksParseChildCursor [cursor]

[42]: rpiswu2 [RPI]

[43]: kksLoadChild [cursor]

[44]: kxsGetRuntimeLock [cursor]

[45]: kksfbc [cursor]

[46]: kkspsc0 [cursor]

[47]: kksParseCursor [cursor]

[48]: opiosq0 [OPI]

[49]: kpooprx [PROGINT_MISC]

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.