Skip Headers
Oracle® Warehouse Builder OMB*Plus Command Reference
11g Release 2 (11.2)

Part Number E14406-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
 

OMBALTER MDL_ACTION_PLAN

Purpose

Modify an existing metadata loader action plan.

Prerequisites

Connection must be established to the repository.

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.