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

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
Mobi · ePub

OMBALTER CORRECTION_SCHEMA_ACTION_PLAN

Purpose

Alter 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.

Syntax

AlterActionPlanCommand =  ( OMBALTER ( ( DEPLOYMENT_ACTION_PLAN | 
          ANALYZE_ACTION_PLAN | CORRECTION_SCHEMA_ACTION_PLAN | 
          CORRECTION_MAPS_ACTION_PLAN ) ) "QUOTED_STRING" ( ( 
          "renameActionPlanClause" { "addActionClause" | "modifyActionClause" | 
          "deleteActionClause" } ) | ( "addActionClause" { "addActionClause" | 
          "modifyActionClause" | "deleteActionClause" } ) | ( 
          "modifyActionClause" { "addActionClause" | "modifyActionClause" | 
          "deleteActionClause" } ) | ( "deleteActionClause" { "addActionClause" 
          | "modifyActionClause" | "deleteActionClause" } ) ) )
     renameActionPlanClause =  RENAME TO "QUOTED_STRING"
     addActionClause =  ADD ACTION "QUOTED_STRING" [ SET "setClause" ]
     modifyActionClause =  MODIFY ACTION "QUOTED_STRING" ( ( 
          "renameActionClause" [ "setUnsetClause" ] ) | "setUnsetClause" )
     deleteActionClause =  DELETE ACTION "QUOTED_STRING"
     setClause =  ( "propertiesClause" [ SET "setReferenceClause" ] ) | 
          "setReferenceClause"
     renameActionClause =  RENAME TO "QUOTED_STRING"
     setUnsetClause =  ( ( SET "setClauseForAlter" ) | ( UNSET 
          "unsetReferenceClause" ) )
     propertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceClause =  ( REF | REFERENCE ) "ObjType" "QUOTED_STRING" { 
          "useClause" }
     setClauseForAlter =  ( "propertiesClause" [ SET "setReferenceClause" | 
          UNSET "unsetReferenceClause" ] ) | "setReferenceClause"
     unsetReferenceClause =  ( REF | REFERENCE )
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     useClause =  USE DATA_RULE_USAGE "QUOTED_STRING"
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

AlterActionPlanCommand

Alter an action plan.

QUOTED_STRING

Action plan name.

renameActionPlanClause

Rename an action plan.

addActionClause

Add an action to an action plan.

QUOTED_STRING

Action name.

modifyActionClause

Modify an action of an action plan.

QUOTED_STRING

Action name.

deleteActionClause

Delete an action of an action plan.

QUOTED_STRING

Action name.

setClause

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

renameActionClause

Rename an action of the action plan.

setUnsetClause

Set the properties and/or associate/disassociate 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.

setClauseForAlter

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

unsetReferenceClause

Disassociate a previously associated object from an action.

propertyNameList

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

propertyValueList

Comma separated list of property values.

useClause

Name of data rule usage.

propertyValue

Value of a property.