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

ORA-22805: cannot insert NULL object into object tables or nested tables

1 Answers  


AMD-00105: Level "string" cannot be added to the hierarchy; the specified parent level "string" is already the parent of "string"

1 Answers  


NNL-01044: Errors reading data stream: number

1 Answers  


LSX-00264: attribute "~S" is prohibited (may not occur)

1 Answers  


ORA-25452: duplicate attribute value for variable: string, attribute: string

1 Answers  


NZE-29095: Index is not correct.

1 Answers  


ORA-12037: unknown export format

1 Answers  


ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

2 Answers  


ORA-15198: operation string is not yet available

1 Answers  


PLS-00427: RPC defaults cannot use builtins when versions of STANDARD differ

1 Answers  


SQL*Loader-00412: More columns specified for table string than the maximum (number)

1 Answers  


TNS-00238: Pump number @: string:

1 Answers  


Categories