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);
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.
The next command detaches the
SALES_HISTORY analytic workspace in the
EXECUTE dbms_aw.aw_detach('sh_aw', 'sales_history');