ORA-31526: could not find source table string.string for CDC
change table string.string
- 1 Answers
- 2213 Views
- I also Faced
- E-Mail Answers
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 |
ORA-25004: WHEN clause is not allowed in INSTEAD OF triggers
ORA-31667: parameter name can not be defaulted
ORA-12057: materialized view "string"."string" is INVALID and must complete refresh
ORA-31158: schema "string" currently being referenced
NNL-00514: Creates a new name with a default TTL
ORA-30082: datetime/interval column to be modified must be empty to decrease fractional second or leading field precision
ORA-39143: dump file "string" may be an original export dump file
AUD-00809: ORDSpeechIndex: unable to ALTER REBUILD internal Text index
DRG-51024: out of memory in stemmer
ORA-12322: unable to mount database (link name string)
ORA-29391: %s and string must be mandatory to create a mandatory plan directive
ORA-25222: enqueue failed, complete sender info. not provided for a queue supporting non-repudiation
Oracle Errors 
