Removal of CDC from 12c
Hello,
We are using CDC in 11g. Recently we have restored a 11g backup to 12c. However i see certain functions of CDC is still restored in 12c which is restricting certain application functionalies.
Getting below error on OPERA PMS on Prem which is on 12c
Error(process_match.set_name_subscription) - Cannot INSERT record: ORA-31495: error in synchronous change table on "OPERA"."NAME_SUBSCRIPTIONS"
ORA-00942: table or view does not exist
When trying to drop the subscription, below error is getting.
ORA-20000: Invalid function (DBMS_CDC_SUBSCRIPTION.drop_subscription); CDC is deprecated
ORA-06512: at "SYS.DBMS_CDC_SUBSCRIBE", line 113