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 MYAW analytic workspace is stored.

SQL> set serveroutput on
SQL> execute dbms_output.put_line('Global is stored in tablespace ' || 
     dbms_aw.aw_tablespace('MYAW_AW', 'MYAW'));
Global is stored in tablespace MYAW_DATA
 
PL/SQL procedure successfully completed.