DBA Data[Home] [Help]

SYS.DBMS_FEATURE_GOLDENGATE dependencies on DBA_CAPTURE

Line 40: from dba_capture where UPPER(purpose) = 'GOLDENGATE CAPTURE';

36: num_delcascadehint := 0;
37: num_suplog := 0;
38:
39: select decode (count(*), 0, 0, 1) into num_capture
40: from dba_capture where UPPER(purpose) = 'GOLDENGATE CAPTURE';
41:
42: select decode (count(*), 0, 0, 1) into num_ds_capture
43: from dba_capture where UPPER(purpose) = 'GOLDENGATE CAPTURE' and
44: UPPER(capture_type) = 'DOWNSTREAM';

Line 43: from dba_capture where UPPER(purpose) = 'GOLDENGATE CAPTURE' and

39: select decode (count(*), 0, 0, 1) into num_capture
40: from dba_capture where UPPER(purpose) = 'GOLDENGATE CAPTURE';
41:
42: select decode (count(*), 0, 0, 1) into num_ds_capture
43: from dba_capture where UPPER(purpose) = 'GOLDENGATE CAPTURE' and
44: UPPER(capture_type) = 'DOWNSTREAM';
45:
46: select decode (count(*), 0, 0, 1) into num_apply from dba_apply
47: where UPPER(purpose) IN ('GOLDENGATE APPLY', 'GOLDENGATE CAPTURE');