How to fix the Oracle error ORA-26744: string capture process “string” does not support “string”.”string” because of the following reason: string?

In this post, you’ll learn more about the Oracle ErrorORA-26744: string capture process “string” does not support “string”.”string” because of the following reason: string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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

How to fix the Error ORA-26744: string capture process “string” does not support “string”.”string” because of the following reason: string ?

You can fix this error in Oracle by following the below steps

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.