Skip Headers
Oracle® OLAP DML Reference
11g Release 2 (11.2)

Part Number E17122-05
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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');