My Oracle Support Banner

Junk characters showing up for CLOB column in Parallel Replicat (Doc ID 2515353.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle GoldenGate - Version 12.3.0.1.0 to 18.1.0.0.0 [Release 12.3 to 12.2]
Information in this document applies to any platform.

Symptoms

Junk Characters Showing up for CLOB column when Parallel Replicat is used.

GGSCI 2> view params <rep name>

replicat <rep name>
userid <username> password <password>
MAP_PARALLELISM 2
MIN_APPLY_PARALLELISM 2
MAX_APPLY_PARALLELISM 4
MAP <schema>.< table>,TARGET <schema>.<table>;


SQL> select * from <schema>.<table>;

ROW_ID          CREATED   CREATED_BY      LAST_UPD  LAST_UPD_BY    
MODIFICATION_NUM CONFLICT_ID     PAR_ROW_ID
--------------- --------- --------------- --------- ---------------
---------------- --------------- ---------------
CRASH_FILE_CONTENT                                                            
   DB_LAST_U DB_LAST_UPD_SRC
------------------------------------------------------------------------------
-- --------- --------------------------------------------------
1-1HNGWFZ       10-NOV-18 0-1             10-NOV-18 0-1                      
     0 0               1-1HNGWFZ
??????????????????????????????????????????????????????????????????????????????
?? 10-NOV-18 Object Manager - Default

1-1HNH38R       10-NOV-18 0-1             10-NOV-18 0-1                      
     0 0               1-1HNH38R
??????????????????????????????????????????????????????????????????????????????
?? 10-NOV-18 Object Manager - Default

 

 

The issue doesn't exist in Classic Replicat and Integrated Replicat.

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.