This content has been marked as final. Show 2 replies
in Chapter about CDC in the Oracle manuls, the error is described and some fixes are mentioned see http://download.oracle.com/docs/cd/B19306_01/server.102/b14223/cdc.htm#i1027192 and scroll a little down.
Normally I try the next code (is also mentioned in above manual):
I hope it starts after the statement. If not have a look at your alert.log, here you can find also errors about CDC.
BEGIN DBMS_CDC_PUBLISH.ALTER_CHANGE_SET( change_set_name => 'YOUR_CHANGE_SET_NAME', recover_after_error => 'y', remove_ddl => 'y'); END; /
Herald ten Dam
Welcome to the forum !!
What CDC configuration is in use?
At high level, here are the steps that you need to follow:
*1.* Check the DBA_APPLY_ERROR view for any exceptions. Main reasons for exception are:
<li> System issues e.g. Disk out of space, tablespace issues
<li> Schema changes, e.g. column datatype got changed because of a DDL
*2.* As mentioned by Herald, execute the ALTER_CHANGE_SET API with recover_after_error => 'Y' and remove_ddl => 'Y' option
*3.* After recovering the change set, enable it using the following API call:
BEGIN DBMS_CDC_PUBLISH.ALTER_CHANGE_SET( change_set_name => 'YOUR_CHANGE_SET_NAME', enable_capture => 'Y'); END; /