My Oracle Support Banner

Moving a Row Between Partitions with Different LOB Storage Fails with ORA-600[kdlrci_get_inline_data] or ORA-7445[__intel_ssse3_rep_memcpy] (Doc ID 2266996.1)

Last updated on FEBRUARY 26, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Creating a partitioned table with one type of LOB storage (securefile vs. basicfile), and then adding a partition to the table that has a different type of LOB storage results in either of the following errors when a row moves between partitions and the table is selected from:

 

a.  If the table is created using basicfile LOB storage and a partition with securefile LOB storage is added:

... kdlrci_get_inline_data kokeicd2m kaf_typed_stuff kafger kafget kdstf00000010000000kmP kdsttgr qertbFetch qergiFetch opifch2 opifch opiodr ttcpip ...

 

-or-

 

b.  If the table is created using securefile LOB storage and a partition with basicfile LOB storage is added:

... __intel_ssse3_rep_memcpy kpctos kpov2adt kpofcr kdstf000000100000000kmP kdsttgr qertbFetch qergiFetch opifch2 ...

 
Note:
When the table is created with a securefile partition and a basicfile partition is added, and then a row is moved, not only does an ORA-3113/ ORA-7445[__intel_ssse3_rep_memcpy] occur, but when you exit the session afterwards you receive:

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Errors in file :
OCI-21500: internal error code, arguments: [kghssgfr1], [0x000000000], [0x001C46180], [], [], [], [], []

The Call Stack Trace in the associated incident trace file shows:

... kghssgfr kodpfi kouotrm kpufhndl0 kpufhndl OCIHandleFree afioci aficnthdf aficexf aficex afiexi aficmd aficfd aficdr afidrv ...

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution
References


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