GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

discard on table with BLOB, but no rows exist in source or target

edited Nov 26, 2012 4:50AM in GoldenGate, Streams and Distributed Database (MOSC) 9 commentsAnswered ✓
RHEL 5.6, Oracle 11.2.0.3.0 RAC, GoldenGate 11.2.1.0
I regularly get entries in my discard file references a table that contains a BLOB. The entry references RAW data so I believe it has something to do with the BLOB.  When I search for the entry in either source or target i find no rows. I'd like to know if anyone understands what is happening here.

here is the table:
desc flux_stb_message
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 FLUX_STB_MESSAGE_QUEUE_ID                 NOT NULL NUMBER
 MESSAGE                                            BLOB
 LAST_MODIFIED_DATE                                 DATE
 REQUEST_BYTES                                      BLOB

Here is the discard entry

Discard record on fetch result = INCONSISTENTROW (11)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center