Oracle Solution for Error ora-25341

ORA-25341: sync_capture does not support "string"."string" because of the following reason:

What triggered the Error:

nc_capture encountered a table with an unsupported property. The most common reason is an unsupported column data type.

What should we do to fix it:

vise the Capture rules to skip over the table in question. One option is to remove the rule that captures changes from the unsupported table. Check DBA_STREAMS_TABLE_RULES to determine the rule on the table specified in the error. Also query the DBA_STREAMS_UNSUPPORTED view to determine which tables are not supported by STREAMS and for what reason. For potential workarounds to certain unsupported properties, see Metalink.