DBA Data[Home] [Help]

SYS.DBMS_FEATURE_STREAMS dependencies on DBA_CAPTURE

Line 25: from dba_capture

21: feature_usage := NULL;
22: total_feature_usage := 0;
23:
24: select decode (count(*), 0, 0, 1) into num_capture
25: from dba_capture
26: where UPPER(purpose) NOT IN ('GOLDENGATE CAPTURE','XSTREAM_OUT');
27:
28: select decode (count(*), 0, 0, 1) into num_ds_capture
29: from dba_capture

Line 29: from dba_capture

25: from dba_capture
26: where UPPER(purpose) NOT IN ('GOLDENGATE CAPTURE','XSTREAM_OUT');
27:
28: select decode (count(*), 0, 0, 1) into num_ds_capture
29: from dba_capture
30: where UPPER(purpose) NOT IN ('GOLDENGATE CAPTURE','XSTREAM_OUT')
31: and UPPER(capture_type) = 'DOWNSTREAM';
32:
33: select decode (count(*), 0, 0, 1) into num_apply