ORA-31526: could not find source table string.string for CDC
change table string.string
- 1 Answers
- 2484 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-02278: duplicate or conflicting MAXVALUE/NOMAXVALUE specifications
ORA-19643: datafile string: incremental-start SCN is too recent
NNL-00560: Shows or sets the server's request-processing delay
ORA-09319: slgtd: unable to obtain the current date and time
NID-00140: Specified database name string does not match previous name used string
ORA-00356: inconsistent lengths in change description
ORA-02031: no ROWID for fixed tables or for external-organized tables
RMAN-08090: channel string: starting proxy restore
ORA-30930: NOCYCLE keyword is required with CONNECT_BY_ISCYCLE pseudocolumn
ORA-31417: column list contains control column string
ORA-29883: cannot create a domain index on column expressions
ORA-16751: Resource guard encountered errors in switchover to primary
Oracle Errors 
