My Oracle Support Banner

APPLY PARAMETER COMPARE_KEY_ONLY DOES NOT WORK AS EXPECTED WHEN TABLE HAS CLOB (Doc ID 1492467.1)

Last updated on FEBRUARY 18, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

 

APPLY PARAMETER COMPARE_KEY_ONLY DOES NOT WORK AS EXPECTED WHEN TABLE HAS CLOB.

ORA-1403 are still recorded in DBA_APPLY_ERRORS;

PK with CLOB:

===========

SQL> create table <SCHEMA>.<TABLE> (<COLUMN1> number primary key, <COLUMN2> varchar2(30)

,<COLUMN3> clob);

Table created.

SQL> insert into <SCHEMA>.<TABLE> values (1,'ABC','A');

1 row created.

SQL> commit;

Commit complete.

SQL> select * from <SCHEMA>.<TABLE>

2 ;

<COLUMN1> <COLUMN2> <COLUMN2>_DESC

---------- ------------------------------

------------------------------------------------------------------------------

--

1 ABC A

SQL> update <SCHEMA>.<TABLE>@<db_connect_string> set <COLUMN2>='ABD';

1 row updated.

SQL> commit;

Commit complete.

SQL> select <COLUMN1> , <COLUMN2> from <SCHEMA>.<TABLE>@db_connect_string;

<COLUMN1> <COLUMN2>

---------- ------------------------------

1 ABD

SQL> select * from <SCHEMA>.<TABLE>;

<COLUMN1> <COLUMN2> <COLUMN2>_DESC

---------- ------------------------------

------------------------------------------------------------------------------

--

1 ABC A

SQL> update <SCHEMA>.<TABLE> set <COLUMN2>='ABC123';

1 row updated.

SQL> commit;

Commit complete.

SQL> select <COLUMN1> , <COLUMN2> from <SCHEMA>.<TABLE>@<db_connect_string>;

<COLUMN1> <COLUMN2>

---------- ------------------------------

1 ABD

DBA_APPLY_ERROR:

================

ORA-26786: A row with key ("<COLUMN1>") = (1) exists but has conflicting column(s)

"<COLUMN2>" in table <SCHEMA>.<TABLE>

ORA-01403: no data found

 

NOTE: If same is performed for the same table without CLOB it works. This

happens only if the table contains CLOB.

 

 

Changes

 NONE.

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.