SQL> BEGIN 2 DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS( 3 schema_names => 'SCHEMA1,SCHEMA2', 4 source_directory_object => 'STREAMS_DIR', 5 destination_directory_object => 'STREAMS_DIR', 6 source_database => 'TESTDB1.DOMAIN.ORG, 7 destination_database => 'TESTDB2.DOMAIN.ORG', 8 capture_name => 'CAPTURE_TESTDB1', 9 capture_queue_table => 'CAPTURE_TESTDB1_QT', 10 capture_queue_name => 'CAPTURE_TESTDB1_QN', 11 capture_queue_user => 'STREAMS_ADMIN', 12 propagation_name => 'PROPAGATION_TESTDB2', 13 apply_name => 'APPLY_TESTDB2', 14 apply_queue_table => 'APPLY_TESTDB2_Qt', 15 apply_queue_name => 'APPLY_TESTDB2_QN', 16 apply_queue_user => 'STREAMS_ADMIN', 17 bi_directional => FALSE, 18 include_ddl => TRUE, 19 instantiation => DBMS_STREAMS_ADM.INSTANTIATION_SCHEMA); 20 END; 21 / BEGIN * ERROR at line 1: ORA-23616: Failure in executing block 28 for script 978E637759E5D040E0430AB9CC29D040 ORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 560 ORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 583 ORA-06512: at "SYS.DBMS_STREAMS_MT", line 2244 ORA-06512: at "SYS.DBMS_STREAMS_MT", line 7507 ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 2606 ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 2667 ORA-06512: at line 2 ======================================================================================================================================== SQL> select * from dba_recoverable_script_errors; SCRIPT_ID BLOCK_NUM ERROR_NUMBER ERROR_MESSAGE ERROR_CREATION_TIM -------------------------------- ---------- ------------ ------------------------------------------------------------ ------------------ 978E637759E5D040E0430AB9CC29D040 28 -900 ORA-00900: invalid SQL statement 29-DEC-10 ORA-06512: at "SYS.DBMS_RECO_SCRIPT_INVOK", line 130 ORA-06512: at "SYS.DBMS_STREAMS_RPC", line 358 978E637759E5D040E0430AB9CC29D040 28 -900 ORA-00900: invalid SQL statement 06-JAN-11 ORA-06512: at "SYS.DBMS_RECO_SCRIPT_INVOK", line 130 ORA-06512: at "SYS.DBMS_STREAMS_RPC", line 358 978E637759E5D040E0430AB9CC29D040 27 -26701 ORA-26701: STREAMS process CAPTURE_TESTDB1 does not exist 29-DEC-10 978E637759E5D040E0430AB9CC29D040 28 -900 ORA-00900: invalid SQL statement 29-DEC-10 ORA-06512: at "SYS.DBMS_RECO_SCRIPT_INVOK", line 130 SCRIPT_ID BLOCK_NUM ERROR_NUMBER ERROR_MESSAGE ERROR_CREATION_TIM -------------------------------- ---------- ------------ ------------------------------------------------------------ ------------------ ORA-06512: at "SYS.DBMS_STREAMS_RPC", line 358 978E637759E5D040E0430AB9CC29D040 27 -26701 ORA-26701: STREAMS process CAPTURE_TESTDB1 does not exist 29-DEC-10 978E637759E5D040E0430AB9CC29D040 27 -26701 ORA-26701: STREAMS process CAPTURE_TESTDB1 does not exist 29-DEC-10 978E637759E5D040E0430AB9CC29D040 27 -26701 ORA-26701: STREAMS process CAPTURE_TESTDB1 does not exist 16-DEC-10 978E637759E5D040E0430AB9CC29D040 27 -26701 ORA-26701: STREAMS process CAPTURE_TESTDB1 does not exist 16-DEC-10 978E637759E5D040E0430AB9CC29D040 28 -900 ORA-00900: invalid SQL statement 16-DEC-10 ORA-06512: at "SYS.DBMS_RECO_SCRIPT_INVOK", line 130 ORA-06512: at "SYS.DBMS_STREAMS_RPC", line 358 978E637759E5D040E0430AB9CC29D040 27 -26701 ORA-26701: STREAMS process CAPTURE_TESTDB1 does not exist 16-DEC-10 SCRIPT_ID BLOCK_NUM ERROR_NUMBER ERROR_MESSAGE ERROR_CREATION_TIM -------------------------------- ---------- ------------ ------------------------------------------------------------ ------------------ 978E637759E5D040E0430AB9CC29D040 27 -26701 ORA-26701: STREAMS process CAPTURE_TESTDB1 does not exist 16-DEC-10 978E637759E5D040E0430AB9CC29D040 28 -900 ORA-00900: invalid SQL statement 16-DEC-10 ORA-06512: at "SYS.DBMS_RECO_SCRIPT_INVOK", line 130 ORA-06512: at "SYS.DBMS_STREAMS_RPC", line 358 978E637759E5D040E0430AB9CC29D040 27 -26701 ORA-26701: STREAMS process CAPTURE_TESTDB1 does not exist 16-DEC-10 978E637759E5D040E0430AB9CC29D040 28 -900 ORA-00900: invalid SQL statement 16-DEC-10 ORA-06512: at "SYS.DBMS_RECO_SCRIPT_INVOK", line 130 ORA-06512: at "SYS.DBMS_STREAMS_RPC", line 358 978E637759E5D040E0430AB9CC29D040 28 -900 ORA-00900: invalid SQL statement 16-DEC-10 SCRIPT_ID BLOCK_NUM ERROR_NUMBER ERROR_MESSAGE ERROR_CREATION_TIM -------------------------------- ---------- ------------ ------------------------------------------------------------ ------------------ ORA-06512: at "SYS.DBMS_RECO_SCRIPT_INVOK", line 130 ORA-06512: at "SYS.DBMS_STREAMS_RPC", line 358 978E637759E5D040E0430AB9CC29D040 27 -26701 ORA-26701: STREAMS process CAPTURE_TESTDB1 does not exist 03-JAN-11 978E637759E5D040E0430AB9CC29D040 28 -900 ORA-00900: invalid SQL statement 16-DEC-10 ORA-06512: at "SYS.DBMS_RECO_SCRIPT_INVOK", line 130 ORA-06512: at "SYS.DBMS_STREAMS_RPC", line 358 978E637759E5D040E0430AB9CC29D040 27 -26701 ORA-26701: STREAMS process CAPTURE_TESTDB1 does not exist 06-JAN-11 978E637759E5D040E0430AB9CC29D040 28 -900 ORA-00900: invalid SQL statement 06-JAN-11 ORA-06512: at "SYS.DBMS_RECO_SCRIPT_INVOK", line 130 SCRIPT_ID BLOCK_NUM ERROR_NUMBER ERROR_MESSAGE ERROR_CREATION_TIM -------------------------------- ---------- ------------ ------------------------------------------------------------ ------------------ ORA-06512: at "SYS.DBMS_STREAMS_RPC", line 358 978E637759E5D040E0430AB9CC29D040 28 -900 ORA-00900: invalid SQL statement 06-JAN-11 ORA-06512: at "SYS.DBMS_RECO_SCRIPT_INVOK", line 130 ORA-06512: at "SYS.DBMS_STREAMS_RPC", line 358 978E637759E5D040E0430AB9CC29D040 27 -26701 ORA-26701: STREAMS process CAPTURE_TESTDB1 does not exist 06-JAN-11 ========================================================================================================================================== ========================================================================================================================================== SQL> exec DBMS_STREAMS_ADM.remove_streams_configuration (); BEGIN DBMS_STREAMS_ADM.remove_streams_configuration (); END; * ERROR at line 1: ORA-06564: object "SCHEMA2"."BIN$kyWzSYLJcGzgQwq5zClwbA==$0" does not exist ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 82 ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 115 ORA-06512: at "SYS.DBMS_CAPTURE_ADM_INTERNAL", line 490 ORA-01403: no data found ORA-06512: at "SYS.DBMS_CAPTURE_ADM", line 395 ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 1877 ORA-06512: at line 1 ========================================================================================================================================== SQL> exec DBMS_STREAMS_ADM.RECOVER_OPERATION('978E637759E5D040E0430AB9CC29D040','ROLLBACK'); BEGIN DBMS_STREAMS_ADM.RECOVER_OPERATION('978E637759E5D040E0430AB9CC29D040','ROLLBACK'); END; * ERROR at line 1: ORA-23616: Failure in executing block 27 for script 978E637759E5D040E0430AB9CC29D040 ORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 560 ORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 583 ORA-06512: at "SYS.DBMS_STREAMS_MT", line 2246 ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 2907 ORA-06512: at line 1