In case of error ORA-00600:
internal error code, arguments: [kwqbdrcp101], [], [], [], [], [], [], [] in alert.log, and you are using Oracle Streams
Stop propagation
exec
DBMS_PROPAGATION_ADM.STOP_PROPAGATION('"[nume_propagare]"');
Drop propagation process
exec
DBMS_PROPAGATION_ADM.DROP_PROPAGATION('"[nume_propagare]"');
Empty queue table for capture process
DECLARE
options dbms_aqadm.aq$_purge_options_t;
BEGIN
options.delivery_mode:=DBMS_AQADM.BUFFERED;
DBMS_AQADM.PURGE_QUEUE_TABLE('"[administrator_streams]"."[nume_captura]_QT"',NULL,options);
END;
/
No comments:
Post a Comment