Skip Headers

Oracle9i OLAP User's Guide
Release 2 (9.2)

Part Number A95295-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

CWM2_OLAP_CUBE, 9 of 16


LOCK_CUBE Procedure

This procedure locks the cube's metadata for update by acquiring a database lock on the row that identifies the cube in the OLAP 2 Catalog.

Syntax

LOCK_CUBE (
           cube_owner        IN   VARCHAR2,
           cube_name         IN   VARCHAR2.
           wait_for_lock     IN   BOOLEAN DEFAULT FALSE);

Parameters

Table 22-8 LOCK_CUBE Procedure Parameters
Parameter Description

cube_owner

Owner of the cube.

cube_name

Name of the cube.

wait_for_lock

(Optional) Whether or not to wait for the cube to be available when it is already locked by another user. If you do not specify a value for this parameter, the procedure does not wait to acquire the lock.

Exceptions

Table 22-9 LOCK_CUBE Procedure Exceptions
Exception Description

no_access_privileges

User does not have the necessary privileges. User must be the owner and have the OLAP_DBA role.

cube_not_found

Cannot lock cube. Cube does not exist within the OLAP 2 Catalog.




Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 2001, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback