select st."RULE_OWNER",st."RULE_NAME",st."TRANSFORM_TYPE",st."FROM_SCHEMA_NAME",st."TO_SCHEMA_NAME",st."FROM_TABLE_NAME",st."TO_TABLE_NAME",st."SCHEMA_NAME",st."TABLE_NAME",st."FROM_COLUMN_NAME",st."TO_COLUMN_NAME",st."COLUMN_NAME",st."COLUMN_VALUE",st."COLUMN_TYPE",st."COLUMN_FUNCTION",st."VALUE_TYPE",st."USER_FUNCTION_NAME",st."SUBSETTING_OPERATION",st."DML_CONDITION",st."DECLARATIVE_TYPE",st."PRECEDENCE",st."STEP_NUMBER"
from "_DBA_SXGG_TRANSFORMATIONS" st
where (st.rule_owner, st.rule_name) NOT IN
(select rule_owner, rule_name from DBA_XSTREAM_RULES
union
select rule_owner, rule_name from DBA_GOLDENGATE_RULES
)
SELECT ST."RULE_OWNER"
, ST."RULE_NAME"
, ST."TRANSFORM_TYPE"
, ST."FROM_SCHEMA_NAME"
, ST."TO_SCHEMA_NAME"
, ST."FROM_TABLE_NAME"
, ST."TO_TABLE_NAME"
, ST."SCHEMA_NAME"
, ST."TABLE_NAME"
, ST."FROM_COLUMN_NAME"
, ST."TO_COLUMN_NAME"
, ST."COLUMN_NAME"
, ST."COLUMN_VALUE"
, ST."COLUMN_TYPE"
, ST."COLUMN_FUNCTION"
, ST."VALUE_TYPE"
, ST."USER_FUNCTION_NAME"
, ST."SUBSETTING_OPERATION"
, ST."DML_CONDITION"
, ST."DECLARATIVE_TYPE"
, ST."PRECEDENCE"
, ST."STEP_NUMBER"
FROM "_DBA_SXGG_TRANSFORMATIONS" ST
WHERE (ST.RULE_OWNER
, ST.RULE_NAME) NOT IN
(SELECT RULE_OWNER
, RULE_NAME
FROM DBA_XSTREAM_RULES
UNION
SELECT RULE_OWNER
, RULE_NAME
FROM DBA_GOLDENGATE_RULES
)
|
|
|