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:

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

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