ORA-23605 When Specifying Tables Owned By Different Schemas In MAINTAIN_TABLES Procedure (Doc ID 735464.1)

Last updated on FEBRUARY 09, 2009

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.6
This problem can occur on any platform.

Symptoms

Calling DBMS_STREAMS_ADM.MAINTAIN_TABLES specifying tables owned by different schemas , as follows:

DECLARE
tables DBMS_UTILITY.UNCL_ARRAY;
BEGIN
tables(1) := 'scott.NEWT';
tables(2) := 'strmuser.NEWTABLE';

DBMS_STREAMS_ADM.MAINTAIN_TABLES(
table_names => tables,
source_directory_object => 'STREAMS_SRC_DIR',
destination_directory_object => 'STREAMS_DEST_DIR',
source_database => 'STRM102A.US.ORACLE.COM',
destination_database => 'STRM102B.US.ORACLE.COM',
perform_actions => TRUE,
script_name => 'configure_rep.sql',
script_directory_object => 'STREAMS_SRC_DIR',
dump_file_name => 'tabs3061807.dmp',
capture_name => 'strmuser_capture',
capture_queue_table => 'strmuser_cap_q_table',
capture_queue_name => 'strmuser_cap_q',
capture_queue_user => NULL,
propagation_name => 'strmuser_propagate',
apply_name => 'strmuser_apply',
apply_queue_table => 'strmuser_apply_q_table',
apply_queue_name => 'strmuser_apply_q',
apply_queue_user => NULL,
log_file => 'instantiate_strmuser.log',
bi_directional => true,
include_ddl => true,
instantiation => DBMS_STREAMS_ADM.INSTANTIATION_TABLE);
END;
/

or

BEGIN
DBMS_STREAMS_ADM.MAINTAIN_TABLES(
table_names => 'scott.NEWT, strmuser.NEWTABLE',
source_directory_object => 'STREAMS_SRC_DIR',
destination_directory_object => 'STREAMS_DEST_DIR',
source_database => 'STRM102A.US.ORACLE.COM',
destination_database => 'STRM102B.US.ORACLE.COM',
perform_actions => TRUE,
script_name => 'configure_rep.sql',
script_directory_object => 'STREAMS_SRC_DIR',
dump_file_name => 'tabs3061807.dmp',
capture_name => 'strmuser_capture',
capture_queue_table => 'strmuser_cap_q_table',
capture_queue_name => 'strmuser_cap_q',
capture_queue_user => NULL,
propagation_name => 'strmuser_propagate',
apply_name => 'strmuser_apply',
apply_queue_table => 'strmuser_apply_q_table',
apply_queue_name => 'strmuser_apply_q',
apply_queue_user => NULL,
log_file => 'instantiate_strmuser.log',
bi_directional => true,
include_ddl => true,
instantiation => DBMS_STREAMS_ADM.INSTANTIATION_TABLE);
END;
/

Fails with:

ERROR at line 1:
ORA-23605: invalid value "tabs3061807.dmp" for STREAMS parameter dump_file_name
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 80
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 123
ORA-06512: at "SYS.DBMS_STREAMS_ADM_UTL", line 325
ORA-06512: at "SYS.DBMS_STREAMS_MT", line 7507
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 2476
ORA-06512: at line 7

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