Oracle Error ORA-26744: string capture process “string” does not support “string”.”string” because of the following reason: string

Oracle Error Message

ORA-26744: string capture process “string” does not support “string”.”string” because of the following reason: string

Reason for the Error

GoldenGate, XStream or Streams capture encountered a table with an unsupported property. The most common reason is an unsupported column data type.

Solution

Revise the Capture rules to skip over the table in question. One way might be to add a negative rule excluding changes from the unsupported table from being captured. Also query the DBA_STREAMS_UNSUPPORTED view to determine which tables are not supported by GoldenGate, XStream or Streams and for what reason. Consider adding negative rules for any tables that may be captured, but are present in this view. For potential workarounds to certain unsupported properties, see Metalink.