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-30109: could not open parameter file 'string'

1 Answers  


ORA-36670: (XSDPART08) workspace object is an INTEGER or NTEXT dimension, or contains an INTEGER or NTEXT dimension. INTEGER and NTEXT dimensions cannot be used as partition dimensions.

1 Answers  


LSX-00001: NULL pointer

1 Answers  


ORA-13249: %s

1 Answers  


ORA-19618: cannot name files after restoreValidate has been called

1 Answers  


ORA-12026: invalid filter column detected

1 Answers  


ORA-01586: database must be mounted EXCLUSIVE and not open for this operation

1 Answers  


ORA-12622: TNS:event notifications are not homogeneous

1 Answers  


NNL-00209: Cache checkpoint interval is currently string

1 Answers  


ORA-00341: log string of thread string, wrong log # string in header

1 Answers  


ORA-01429: Index-Organized Table: no data segment to store overflow row-pieces

1 Answers  


ORA-16224: Database Guard is enabled

1 Answers  


Categories