../E14406-01.epub /> ../E14406-01.mobi />

OMBALTER DEPLOYMENT_ACTION_PLAN

Purpose

Modify an existing deployment action plan.

Prerequisites

There must be a current working project.

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.