Oracle Solution for Error ora-31424

ORA-31424: change table has active subscriptions

What triggered the Error:

The change table is subscribed to, so it cannot be dropped.

What should we do to fix it:

Do not drop a change table while there are active subscribers. If this is an emergency, use the FORCE parameter. This will forcibly drop the change table out from under all subscribers.