My Oracle Support Banner

Error ORA-23621 When Calling DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS (Doc ID 456680.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.


In a bidirectional Streams setup you get the following stack error when calling DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS:


3 schema_names => 'stream_usr',
4 source_directory_object =>'expdir',
5 destination_directory_object => 'impdir',
6 source_database => 'SRC_DB',
7 destination_database =>'DEST_DB',
8 capture_queue_table => 'cap1_qt',
9 capture_queue_name => 'cap1_q_name',
10 apply_queue_table => 'apply1_qt',
11 apply_queue_name => 'apply1_q_name',
12 capture_name => 'cap1_cip',
13 propagation_name => 'prop1_cip',
14 APPLY_NAME => 'apply1_cip',
15 include_ddl => true,
16 bi_directional => true);
17 end;
18 /
ERROR at line 1:
ORA-23621: Operation corresponding to script 34ACEFADB2C070D3E044000000000000 is in progress.
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_STREAMS_MT", line 2328
ORA-06512: at "SYS.DBMS_STREAMS_MT", line 7451
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 2624
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 2685
ORA-06512: at line 2


You retry the above procedure after removing current Streams setup via DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION but you get same error ORA-23621.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.