ORA-26663 for removing process Errors When configuring Streams:
SQL> exec dbms_apply_adm.drop_apply ('target _ APPLY_STREAM ');
BEGIN dbms_apply_adm.drop_apply ('target _ APPLY_STREAM '); END;
*
ERROR at line 1:
ORA-26663: error queue for apply process ORA-26663: error queue for apply
Process TARGET_APPLY_STREAM must be empty
Must be empty
ORA-06512: at "SYS. DBMS_APPLY_ADM_INTERNAL", line 359
ORA-06512: at "SYS. DBMS_APPLY_ADM_INTERNAL", line 334
ORA-06512: at "SYS. DBMS_APPLY_ADM", line 690
ORA-06512: at line 1
These error messages need to be deleted from the table:
Select * from dba_apply_error
Exec DBMS_APPLY_ADM.DELETE_ALL_ERRORS (apply_name => 'target _ APPLY_STREAM ')
Execute again
Exec dbms_apply_adm.drop_apply ('target _ APPLY_STREAM ');
The process for deleting the configuration is as follows:
Select capture_name from dba_capture
Exec dbms_capture_adm.drop_capture ('capture _ stream ')
Select propagation_name from dba_propagation
Exec dbms_propagation_adm.drop_propagation ('source _ TO_TARGET ')
Select apply_name from dba_apply
Exec dbms_apply_adm.drop_apply ('target _ APPLY_STREAM ')
Clear the entire streams configuration: (this will delete the Streams configuration in the entire database. If there are two streams users, the processes of these two users will be deleted clearly)
Exec dbms_streams_adm.remove_streams_configuration;