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 MYAW analytic workspace.

SQL>execute dbms_aw.aw_detach('myaw');