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.
