Shareplex picks up wrong column as the key.
For Example
The object cache shows that key columns are COL1, COL2 and COL3
"XXXX"."ABCD"
340604
Type: TABLE
Key Type: Primary key Number of key columns: 3
Number of columns: 185
Status: In Replication
--------------------------------------------------------------------------------
Col |Length| Type | Name | Column info
1 23 VARCHAR2 COL1 Key
2 5 VARCHAR2 COL2 Key
3 20 VARCHAR2 COL3 Key
4 1 VARCHAR2 COL4
5 20 VARCHAR2 COL5
..........
Whereas the primary key has only two columns:
SQL> select column_name, position from dba_cons_columns where constraint_name='ABCD_PK' and table_name='ABCD';
COLUMN_NAME POSITION
----------------------- ----------------
COL1 1
COL2 2
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center