Skip Headers
Oracle® OLAP DML Reference
11g Release 2 (11.2)

E17122-08
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

AW_DETACH Procedure

The AW_DETACH procedure detaches an analytic workspace from your session so that its contents are no longer accessible. All changes that you have made since the last update are discarded. Refer to "AW_UPDATE Procedure" for information about saving changes to an analytic workspace.

Syntax

AW_DETACH ( 
          awname        IN VARCHAR2);
AW_DETACH ( 
          schema        IN VARCHAR2,
          awname        IN VARCHAR2);

Parameters

Table B-15 AW_DETACH Procedure Parameters

Parameter Description

schema

The schema that owns awname.

awname

The name of an attached analytic workspace that you want to detach from your session.


Example

The following command detaches the GLOBAL_FINANCE analytic workspace.

EXECUTE dbms_aw.aw_detach('global_finance');

The next command detaches the SALES_HISTORY analytic workspace in the SH_AW schema.

EXECUTE dbms_aw.aw_detach('sh_aw', 'sales_history');