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
Modify an existing deployment action plan.
renameActionPlanClause
Rename an action plan.
addActionClause
Add an action to an action plan.
modifyActionClause
Modify an action of an action plan.
deleteActionClause
Remove an action from an action plan.
setClause
Set the properties of an action and/or associate an object with an action.
renameActionClause
Rename an action.
setUnsetClause
Set the properties and/or associate/disassociate an object with an action.
propertiesClause
Associate a set of properties with an action.
PROPERTIES
OPERATION, which specifies the type of action to be taken. DEPLOYMENT_LOCATION, which sets the target location for a Code Template.
setReferenceClause
Associate an object with an action.
ObjType
Object type. Valid values are ADVANCED_QUEUE, CUBE, DIMENSION, EXTERNAL_TABLE, CONNECTOR, FUNCTION, MAPPING, MATERIALIZED_VIEW, PROCEDURE, PROCESS_FLOW_PACKAGE, SCHEDULABLE, SEQUENCE, TABLE, and VIEW.
QUOTED_STRING
Absolute or relative path name of an object (e.g. '/MY_PROJECT/MODULE_X/TABLE_Y'). Global objects (for example public transforms), require a relative path.
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. Valid values for OPERATION are DROP, CREATE, REPLACE and UPGRADE.
