select rg.refresh_group_id, rg.refresh_group_name, rt.refresh_template_id,
rt.refresh_template_name, rg.rollback_seg, rg.start_date, rg.interval
from system.repcat$_refresh_templates rt,
system.repcat$_template_refgroups rg,
system.repcat$_template_types tt
where rt.refresh_template_id = rg.refresh_template_id
and rt.template_type_id = tt.template_type_id
and bitand(rawtohex(tt.flags),1) = 1
SELECT RG.REFRESH_GROUP_ID
, RG.REFRESH_GROUP_NAME
, RT.REFRESH_TEMPLATE_ID
,
RT.REFRESH_TEMPLATE_NAME
, RG.ROLLBACK_SEG
, RG.START_DATE
, RG.INTERVAL
FROM SYSTEM.REPCAT$_REFRESH_TEMPLATES RT
,
SYSTEM.REPCAT$_TEMPLATE_REFGROUPS RG
,
SYSTEM.REPCAT$_TEMPLATE_TYPES TT
WHERE RT.REFRESH_TEMPLATE_ID = RG.REFRESH_TEMPLATE_ID
AND RT.TEMPLATE_TYPE_ID = TT.TEMPLATE_TYPE_ID
AND BITAND(RAWTOHEX(TT.FLAGS)
, 1) = 1
|
|
|