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

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
Mobi · ePub

OMBLOCK

Purpose

Lock one or more objects. If a list of objects is specified, the objects will be locked one by one in the given order. The command will behave atomically, i.e. if it fails to lock any of the objects in the list, then it will lock none of them.

Prerequisites

No other user should have a lock on any of the objects.

Syntax

parseLockCommand =  OMBLOCK "parseTypeNameList" 
     parseTypeNameList =  "objectType" "QUOTED_STRING" { "," "objectType" 
          "QUOTED_STRING" }
     objectType =  ( ADVANCED_QUEUE | BUSINESS_AREA | CATALOG_FOLDER | 
          COLLECTION | CONNECTOR | CONFIGURATION | DEPLOYMENT | CUBE | DIMENSION
           | EXPERT | EXPERT_MODULE | CT | CT_FOLDER | EXTERNAL_TABLE | 
          FLAT_FILE_MODULE | FLAT_FILE | FUNCTION | TABLE_FUNCTION | 
          GATEWAY_MODULE | BUSINESS_DEFINITION_MODULE | 
          OBIEE_BUSINESS_DEFINITION_MODULE | REGISTERED_FUNCTION | LOCATION | 
          LOGICAL_TABLE | MAPPING | MATERIALIZED_VIEW | OBJECT_TYPE | 
          VARYING_ARRAY | NESTED_TABLE | ORACLE_MODULE | PACKAGE | PROCEDURE | 
          PROCESS_FLOW | PROCESS_FLOW_MODULE | PROCESS_FLOW_PACKAGE | 
          WEB_SERVICE | WEB_SERVICE_PACKAGE | APPLICATION_SERVER_MODULE | 
          PROJECT | ITEM_FOLDER | DRILL_PATH | LIST_OF_VALUES | DRILL_TO_DETAIL 
          | ALTERNATIVE_SORT_ORDER | CONTROL_CENTER | MODULE | SAP_MODULE | 
          CMI_MODULE | SEQUENCE | TABLE | VIEW | CMI_DEFINITION | 
          PLSQL_RECORD_TYPE | "UNQUOTED_STRING" )

Parameters

parseLockCommand

Specify lock command.

parseTypeNameList

Specify the object or the list of objects to be locked.

QUOTED_STRING

Name of the object to be locked. Can be specified as an absolute path or as a path relative to the current context. However, there is the restriction that all objects to be locked must be in the current project.

objectType

Type of the object to be locked.

See Also

OMBUNLOCK