Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The AW_DELETE
procedure deletes an existing analytic workspace.
AW_DELETE ( awname IN VARCHAR2);
AW_DELETE ( schema IN VARCHAR2, awname IN VARCHAR2);
Table B-14 AW_DELETE Procedure Parameters
Parameter | Description |
---|---|
|
The schema that owns awname. |
|
The name of an existing analytic workspace that you want to delete along with all of its contents. You must be the owner of awname or have DBA rights to delete it, and it cannot currently be attached to your session. The AW$awname file is deleted from the database. |
The following command deletes the SALES_DEMO
analytic workspace in the user's default schema.
EXECUTE dbms_aw.aw_delete('sales_demo');