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.
