ORA-23622: Operation SYS.DBMS STREAMS ADM.MAINTAIN CHANGE TABLE is in progress.

From Robs_Wiki
Revision as of 09:40, 24 January 2020 by Qadmin wiki (talk | contribs) (Created page with "__TOC__ == Analysis == This error most likely happens when you use Oracle Streams and when an error occurred, for example when you set up a streams configuration and have mad...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Analysis

This error most likely happens when you use Oracle Streams and when an error occurred, for example when you set up a streams configuration and have made an error. After that, the transaction failed, but is still open.

Solution

Find out the script id of the transaction:

SQL> select script_id from DBA_RECOVERABLE_SCRIPT ;

SCRIPT_ID
--------------------------------
9CDF721F1C221F81E05400144FFB4175

Rollback the transaction:

SQL> exec DBMS_STREAMS_ADM.RECOVER_OPERATION('9CDF721F1C221F81E05400144FFB4175','ROLLBACK');