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

OMBUNLOCK

Purpose

Unlock one or more objects, previously locked by OMBLOCK command. Note that if the object(s) have been modified, save or revert is also required in order for the lock(s) to be released.

Prerequisites

The object(s) should have been locked previously using OMBLOCK command.

Syntax

parseUnLockCommand =  OMBUNLOCK "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

parseUnLockCommand

Specify unlock command.

parseTypeNameList

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

QUOTED_STRING

Name of the object to be unlocked. 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 unlocked must be in the current project.

objectType

Type of the object to be unlocked.

See Also

OMBLOCK