AW_DELETE Procedure

The AW_DELETE procedure deletes an existing analytic workspace.

Syntax

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

Parameters

Table B-14 AW_DELETE Procedure Parameters

Parameter Description

schema

The schema that owns awname.

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.


Example

The following command deletes the SALES_DEMO analytic workspace in the user's default schema.

EXECUTE dbms_aw.aw_delete('sales_demo');