DBA Data[Home] [Help]

VIEW: SYS.CDB_GOLDENGATE_RULES

Source

View Text - Preformatted

SELECT "COMPONENT_NAME","COMPONENT_TYPE","COMPONENT_RULE_TYPE","RULE_SET_OWNER","RULE_SET_NAME","RULE_SET_TYPE","RULE_OWNER","RULE_NAME","RULE_TYPE","RULE_CONDITION","SCHEMA_NAME","OBJECT_NAME","INCLUDE_TAGGED_LCR","SUBSETTING_OPERATION","DML_CONDITION","SOURCE_DATABASE","ORIGINAL_RULE_CONDITION","SAME_RULE_CONDITION","SOURCE_ROOT_NAME","SOURCE_CONTAINER_NAME","CON_ID" FROM CONTAINERS("SYS"."DBA_GOLDENGATE_RULES")
View Text - HTML Formatted

SELECT "COMPONENT_NAME"
, "COMPONENT_TYPE"
, "COMPONENT_RULE_TYPE"
, "RULE_SET_OWNER"
, "RULE_SET_NAME"
, "RULE_SET_TYPE"
, "RULE_OWNER"
, "RULE_NAME"
, "RULE_TYPE"
, "RULE_CONDITION"
, "SCHEMA_NAME"
, "OBJECT_NAME"
, "INCLUDE_TAGGED_LCR"
, "SUBSETTING_OPERATION"
, "DML_CONDITION"
, "SOURCE_DATABASE"
, "ORIGINAL_RULE_CONDITION"
, "SAME_RULE_CONDITION"
, "SOURCE_ROOT_NAME"
, "SOURCE_CONTAINER_NAME"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_GOLDENGATE_RULES")