AW_TABLESPACE Function

The AW_TABLESPACE function returns the name of the tablespace in which a particular analytic workspace is stored.

Note:

You cannot execute this function from within the OLAP Worksheet. You must execute if in a SQL tool such as SQL*Plus.

Syntax

AW_TABLESPACE ( 
          awname        IN VARCHAR2)
     RETURN VARCHAR2;

AW_TABLESPACE ( 
          schema        IN VARCHAR2,
          awname        IN VARCHAR2)
     RETURN VARCHAR2;

Returns

Name of a tablespace.

Parameters

Table B-17 AW_TABLESPACE Function Parameters

Parameter	Description
`schema`	The schema that owns awname.
`awname`	The name of an analytic workspace.

Example

The following example shows the tablespace in which the GLOBAL analytic workspace is stored.

SET serveroutput ON

EXECUTE dbms_output.put_line('Sales History is stored in tablespace ' || 
     dbms_aw.aw_tablespace('sh_aw', 'sales_history'));

This command generates the following statement:

Sales History is stored in tablespace SH_AW