Tuesday, September 20, 2011

ORA-00600: internal error code, arguments: [kwqbdrcp101], [], [], [], [], [], [], []



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