Syntax
alterMDLActionPlanCommand = ( OMBALTER ( MDL_ACTION_PLAN ) "QUOTED_STRING"
( "alterActionPlanClause" { "alterActionPlanClause" } ) )
alterActionPlanClause = "renameActionPlanClause" | "addActionClause" |
"deleteActionClause" | "modifyActionClause"
renameActionPlanClause = RENAME TO "QUOTED_STRING"
addActionClause = ADD ACTION "QUOTED_STRING" "setReferenceClause"
deleteActionClause = DELETE ACTION "QUOTED_STRING"
modifyActionClause = MODIFY ACTION "QUOTED_STRING" "modifyActionOperation"
{ "modifyActionOperation" }
setReferenceClause = SET ( REF | REFERENCE ) ( "referenceValueClause" )
modifyActionOperation = "renameActionClause" | "setReferenceClause" |
"deleteReferenceClause"
referenceValueClause = "objectTypeValue" "QUOTED_STRING" [ SET ( REF |
REFERENCE ) "referenceValueClause" ]
renameActionClause = RENAME TO "QUOTED_STRING"
deleteReferenceClause = DELETE REFERENCE "objectTypeValue" "QUOTED_STRING"
objectTypeValue = ( PROJECT | ORACLE_MODULE | TABLE | VIEW | SEQUENCE |
MATERIALIZED_VIEW | FUNCTION | PROCEDURE | PACKAGE | DIMENSION | CUBE
| ADVANCED_QUEUE | MAPPING | REAL_TIME_MAPPING | PROCESS_FLOW_MODULE |
PROCESS_FLOW_PACKAGE | PROCESS_FLOW | APPLICATION_SERVER_MODULE |
WEB_SERVICE_PACKAGE | WEB_SERVICE | SAP_MODULE | CMI_MODULE |
GATEWAY_MODULE | EXTERNAL_TABLE | FLAT_FILE_MODULE | FLAT_FILE |
BUSINESS_DEFINITION_MODULE | OBIEE_BUSINESS_DEFINITION_MODULE |
ITEM_FOLDER | LOGICAL_TABLE | LIST_OF_VALUES | DRILL_TO_DETAIL |
ALTERNATIVE_SORT_ORDER | DRILL_PATH | BUSINESS_AREA | CATALOG_FOLDER |
LOCATION | CONNECTOR | CONTROL_CENTER | CONFIGURATION | COLLECTION |
SNAPSHOT | ROLE | USER | ICONSET | TRANSFORMATION_MODULE |
CALENDAR_MODULE | CALENDAR_FOLDER | CALENDAR | EXPERT_MODULE | EXPERT
| CT_FOLDER | CT | DATA_RULE_MODULE | DATA_RULE | DATA_AUDITOR |
QUEUE_TABLE | QUEUE_PROPAGATION | OBJECT_TYPE | NESTED_TABLE |
VARYING_ARRAY | DEPLOYMENT | DATA_PROFILE | PROFILE_REFERENCE |
PLSQL_TABLE_TYPE | PLSQL_RECORD_TYPE | PLSQL_REF_CURSOR_TYPE |
PLUGGABLE_MAPPING | PLUGGABLE_MAPPING_FOLDER |
PLUGGABLE_MAPPING_LIBRARY | CMI_DEFINITION | ACTIVITY_TEMPLATE |
ACTIVITY_TEMPLATE_FOLDER | TRANSPORTABLE_MODULE | MODULE )
Parameters
alterMDLActionPlanCommand
Modify an existing metadata loader action plan.
alterActionPlanClause
The type of altering that can be performed on the action plan.
renameActionPlanClause
Rename an action plan.
addActionClause
Add an action to an action plan.
deleteActionClause
Removes an action from an action plan.
modifyActionClause
Modify an action of an action plan.
setReferenceClause
Specify the object type and the absolute path name of an object.
modifyActionOperation
The type of operations that can be performed on an action.
referenceValueClause
Specify a first-class object type and the absolute pathname of an object.
QUOTED_STRING
Absolute path name of an object (e.g. '/MY_PROJECT/MODULE_X/TABLE_Y').
renameActionClause
Rename an action of an action plan.
deleteReferenceClause
Remove a reference object from an action plan.
objectTypeValue
The first-class object type that is allowed to be specified in the referenceValueClause.
