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

Last updated on JULY 05, 2017

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms