25 lines
396 B
Plaintext
Executable File
25 lines
396 B
Plaintext
Executable File
-- LIST CAPTURES
|
|
|
|
set lines 180
|
|
col CAPTURE_NAME for a50
|
|
|
|
select CAPTURE_NAME,STATUS from dba_capture;
|
|
|
|
-- STOP CAPTURE
|
|
|
|
BEGIN
|
|
DBMS_CAPTURE_ADM.STOP_CAPTURE(
|
|
capture_name => 'OGG$CAP_OEDCLJJ',
|
|
force => true);
|
|
END;
|
|
/
|
|
|
|
-- DROP CAPTURE
|
|
|
|
BEGIN
|
|
DBMS_CAPTURE_ADM.DROP_CAPTURE(
|
|
capture_name => 'OGG$CAP_OEDINJJ',
|
|
drop_unused_rule_sets => true);
|
|
END;
|
|
/
|