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

文档解释

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

Cause: A source column was missing for an imported Change Data Capture change 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 missing source table.

ORA-31527：查找CDC更改表string.string的源列字符串失败。

官方解释

ORA-31527: 无法为指定的CDC更改表找到源列字符串

常见案例

该错误代码通常提示管理员源表中没有足够的字段以便在现表中捕获更改。

一般处理方法及步骤

1. 对于错误代码，可以采用原来的表添加列来解决问题，并且将CDC_CHANGES管理表中的数据删掉。

2. 重新装入CDC_CHANGES表中的默认值即可。