Skip Headers
Oracle® Warehouse Builder OMB*Plus Command Reference
11g Release 2 (11.2)

Part Number E14406-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
 

OMBCREATE CORRECTION_SCHEMA_ACTION_PLAN

Purpose

Create an action plan for creating a correction schema, identifying the tables that will be mapped to that schema.

Prerequisites

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.

Syntax

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" )

Parameters

CreateActionPlanCommand

Create a correcton schmema action plan.

QUOTED_STRING

Action plan name.

addActionClause

Add an action to an action plan.

QUOTED_STRING

Action name.

setClause

Set the properties of an action and/or associate an object with an action.

propertiesClause

Set the properties and/or associate/disassociate an object with an action.

setReferenceClause

Associate an object with an action.

ObjType

Object type. The only valid value is DATA_PROFILE_TABLE.

propertyNameList

Comma separated list of property names. Property names are unquoted.

propertyValueList

Comma separated list of property values.

useClause

Use data rule in construction of correction schema.

QUOTED_STRING

Name of data rule usage.

propertyValue

Value of a property.

See Also

OMBPROFILE