ORA-00600 Upon 'alter Table [name] No Row Archival' (Doc ID 1597161.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.1 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Row archival disable on a partitioned table fails with

ORA-00600: internal error code, arguments: [kkpoxgsoh:X], [0x079D73FA8], [2],[], [], [], [], [], [], [], [], []

The issue happens under the following call stack:

kkpoxgsoh_get_shared_object_handle_0 kkpox_invalidate_vobj atbdrv opiexe opiosq0 kpoal8 opiodr ttcpip opitsk opiino

 

 e.g.

SQL> CREATE TABLE sales
( invoice_no NUMBER,
 2    3  sale_year INT NOT NULL,
 4  sale_month INT NOT NULL,
 5  sale_day INT NOT NULL )
 6  PARTITION BY RANGE (sale_year, sale_month, sale_day)
 7  ( PARTITION sales_q1 VALUES LESS THAN (1999, 04, 01)
 8  ,
 9  PARTITION sales_q2 VALUES LESS THAN (1999, 07, 01)
10  ,
11  PARTITION sales_q3 VALUES LESS THAN (1999, 10, 01)
12  ,
13  PARTITION sales_q4 VALUES LESS THAN (2000, 01, 01)
14  );

Table created.

SQL> alter table sales row archival;

Table altered.

SQL> alter table sales no row archival;
alter table sales no row archival
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kkpoxgsoh:X], [0x079D73FA8], [2],
[], [], [], [], [], [], [], [], []

 



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms