ORA-31424: change table has active subscriptions



ORA-31424: change table has active subscriptions..

Answer / guest

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

Action: 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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00507: a PLSQL Table may not contain a table or a record with composite fields

2 Answers  


NNO-00624: setting auto-refresh expiration period to number seconds

1 Answers  


SQL*Loader-00801: all INTO TABLE clauses must have the same options (string)

1 Answers  


ORA-02175: invalid rollback segment name

1 Answers  


ORA-26712: remote object is "string"."string"\@"string"

1 Answers  






ORA-30076: invalid extract field for extract source

1 Answers  


DRG-11609: URL store: unable to open local file specified by string

1 Answers  


ORA-30450: refresh_after_errors was TRUE; The following MVs could not be refreshed: string

1 Answers  


DRG-11731: translation does not exist

1 Answers  


RMAN-06456: command is obsolete

1 Answers  


NNL-00522: Removes a data item from a name by value or by type

1 Answers  


ORA-19776: PROXY restore to ASM diskgroup "string" is not supported.

1 Answers  


Categories