select rt.refresh_template_name ias_template_name,
decode(ro.object_type, -1017, to_number(ro.object_name), 0) lineno, ddl_text
from system.repcat$_refresh_templates rt,
system.repcat$_template_objects ro,
system.repcat$_template_types tt
where rt.template_type_id = tt.template_type_id
and bitand(rawtohex(tt.flags),2) = 2
and rt.refresh_template_id = ro.refresh_template_id
and ro.object_type = -1017 -- object_type = dbms_ias_template.generated_ddl
SELECT RT.REFRESH_TEMPLATE_NAME IAS_TEMPLATE_NAME
,
DECODE(RO.OBJECT_TYPE
, -1017
, TO_NUMBER(RO.OBJECT_NAME)
, 0) LINENO
, DDL_TEXT
FROM SYSTEM.REPCAT$_REFRESH_TEMPLATES RT
,
SYSTEM.REPCAT$_TEMPLATE_OBJECTS RO
,
SYSTEM.REPCAT$_TEMPLATE_TYPES TT
WHERE RT.TEMPLATE_TYPE_ID = TT.TEMPLATE_TYPE_ID
AND BITAND(RAWTOHEX(TT.FLAGS)
, 2) = 2
AND RT.REFRESH_TEMPLATE_ID = RO.REFRESH_TEMPLATE_ID
AND RO.OBJECT_TYPE = -1017 -- OBJECT_TYPE = DBMS_IAS_TEMPLATE.GENERATED_DDL
|
|
|