ORA-31526: could not find source table string.string for CDC
change table string.string



ORA-31526: could not find source table string.string for CDC change table string.string..

Answer / guest

Cause: The source table was missing or was not set up
correctly for an imported Change Data Capture change table.
A synchronous change table requires the source table to
exist and have the Change Data Capture trigger defined on
it. An asynchronous change table requires table rules to be
defined for the source table.

Action: Drop the imported change table because it is
invalid. Verify that the schema containing the source table
was included in the original export. If needed, perform the
export again, including the schema of the source table. If
change table is asynchronous, ensure that
STREAMS_CONFIGURATION=y is specified for the import.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-23312: not the masterdef according to string

1 Answers  


IMG-00582: output format does not support the specified interleave

1 Answers  


TNS-01075: Opened log file: string

1 Answers  


ORA-21300: objects option not installed

1 Answers  


ORA-03288: both FREELIST GROUP and INSTANCE parameters may not be specified

1 Answers  


IMP-00006: failed to allocate memory of size number

1 Answers  


ORA-12714: invalid national character set specified

1 Answers  


ORA-23387: replication parallel push dequeue error

1 Answers  


ORA-29908: missing primary invocation for ancillary operator

1 Answers  


ORA-36202: (XSAGOP01) 'number' is not a valid aggregation operator.

1 Answers  


RMAN-06250: Report of files that need backup due to unrecoverable operations

1 Answers  


TNS-04141: Unable to find CMAN.ORA file.

1 Answers  


Categories