OMBALTER ANALYZE_ACTION_PLAN

Purpose

To alter an existing profile action plan.

Prerequisites

alterAnalyzeActionPlanPreTag??

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

Currently used only in CORRECTION_SCHEMA_ACTION_PLAN.

propertyValue

Value of a property.

See Also

OMBCREATE ANALYZE_ACTION_PLAN

OMBPROFILE