Oracle® Warehouse Builder OMB*Plus Command Reference 11g Release 2 (11.2) Part Number E14406-01 |
|
|
Mobi · ePub |
Create an action plan for creating a correction schema, identifying the tables that will be mapped to that schema.
In the context of a data profile. First do OMBCREATE DATA_RULE, and OMBALTER TABLE 'T' ADD DATA_RULE_USAGE, on the profile tables that will be mapped.
CreateActionPlanCommand = ( OMBCREATE TRANSIENT ( ( DEPLOYMENT_ACTION_PLAN | ANALYZE_ACTION_PLAN | CORRECTION_SCHEMA_ACTION_PLAN | CORRECTION_MAPS_ACTION_PLAN ) ) "QUOTED_STRING" { "addActionClause" } ) addActionClause = ADD ACTION "QUOTED_STRING" [ SET "setClause" ] setClause = ( "propertiesClause" [ SET "setReferenceClause" ] ) | "setReferenceClause" propertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")" setReferenceClause = ( REF | REFERENCE ) "ObjType" "QUOTED_STRING" { "useClause" } propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" } propertyValueList = "propertyValue" { "," "propertyValue" } useClause = USE DATA_RULE_USAGE "QUOTED_STRING" propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" )