Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
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.
AW_DETACH ( awname IN VARCHAR2);
AW_DETACH ( schema IN VARCHAR2, awname IN VARCHAR2);
Table B-15 AW_DETACH Procedure Parameters
Parameter | Description |
---|---|
|
The schema that owns awname. |
|
The name of an attached analytic workspace that you want to detach from your session. |
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');