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.