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 to [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.


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 ...




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 ...

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 - 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 ...





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

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