Oracle Error ORA-31424: change table has active subscriptions

Oracle Error Message

ORA-31424: change table has active subscriptions

Reason for the Error

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

Solution

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.