Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center