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
 

OMBCREATE MDL_ACTION_PLAN

Purpose

Create a metadataloader action plan.

Prerequisites

Connection must be established to the repository.

Syntax

createMDLActionPlanCommand =  ( OMBCREATE TRANSIENT MDL_ACTION_PLAN 
          "QUOTED_STRING" { "addActionClause" } )
     addActionClause =  ADD ACTION "QUOTED_STRING" "setReferenceClause"
     setReferenceClause =  SET ( REF | REFERENCE ) ( "referenceValueClause" )
     referenceValueClause =  "objectTypeValue" "QUOTED_STRING" [ SET ( REF | 
          REFERENCE ) "referenceValueClause" ]
     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

createMDLActionPlanCommand

Create a metadata loader action plan.

QUOTED_STRING

Name of the action plan in a single-quoted string. It is case-insensitive.

addActionClause

Add an action to an action plan.

QUOTED_STRING

Name of the action in a single-quoted string. It is case-insensitive. Must be unquie within an action plan.

setReferenceClause

Specify the object type and the absolute path name of an object.

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').

objectTypeValue

The first-class object type that is allowed to be specified in the referenceValueClause.