My Oracle Support Banner

Stream Setup Using DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS Fails with ORA-44001 (Doc ID 1424055.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.3 [Release 9.2 to 11.2]
Information in this document applies to any platform.

Symptoms

Setting up Streams by calling DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS fails as follows:


SQL> connect STRMADMIN/******
SQL> Connected.
SQL> DECLARE
SQL> schemas DBMS_UTILITY.UNCL_ARRAY
SQL> BEGIN
SQL> schemas(1) := '"TEST"'
SQL> DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS(
SQL> schema_names => schemas,
SQL> source_directory_object => 'TEST_DIR',
SQL> destination_directory_object => 'TEST_DIR',
SQL> source_database => 'SOURCE.WORLD',
SQL> destination_database => 'DEST.WORLD',
SQL> perform_actions => TRUE,
SQL> script_name => 'streams_setup_2012_2_22_16_46_10_861.sql',
SQL> script_directory_object => 'TEST_DIR',
SQL> dump_file_name => 'streams_setup_2012_2_22_16_46_10_861.dmp',
SQL> capture_queue_user => 'STRMADMIN',
SQL> apply_queue_user => 'strmadmin',
SQL> apply_queue_table => '"strmadmin".APP_QT',
SQL> apply_queue_name => '"strmadmin".APP_Q',
SQL> log_file => 'streams_setup_2012_2_22_16_46_10_861.log',
SQL> bi_directional => true,
SQL> include_ddl => true)
SQL> END
SQL> /
SQL> 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 DECLARE
*
ERROR at line 1:
ORA-23616: Failure in executing block 1 for script
B99724D209B601BCE0438EB2D5A501BC with
ORA-44001: invalid schema
ORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 659
ORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 682
ORA-06512: at "SYS.DBMS_STREAMS_MT", line 7983
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 2703
ORA-06512: at line 5

Cause

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
Symptoms
Cause
Solution

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