AW_CREATE Procedure

The AW_CREATE procedure creates a new, empty analytic workspace and makes it the current workspace in your session.

The current workspace is first in the list of attached workspaces.

Note:

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

Syntax

AW_CREATE ( 
           awname        IN VARCHAR2 ,
           tablespace    IN VARCHAR2 DEFAULT NULL ,
           partnum       IN NUMBER DEFAULT 8 );

AW_CREATE ( 
           schema        IN VARCHAR2 ,
           awname        IN VARCHAR2 ,
           tablespace    IN VARCHAR2 DEFAULT NULL);

Parameters

Table B-13 AW_CREATE Procedure Parameters

Parameter	Description
`schema`	The schema that owns awname.
`awname`	The name of a new analytic workspace. The name must comply with the naming requirements for a table in Oracle Database. This procedure creates a table named AW$awname, in which the analytic workspace is stored.
`tablespace`	The tablespace in which the analytic workspace will be created. If you omit this parameter, the analytic workspace is created in your default tablespace.
`partnum`	The number of partitions that will be created for the `AW$`awname table.

Example

The following command creates a new, empty analytic workspace named MYAW. The new analytic workspace is stored in a table named AW$MYAW with eight partitions in the user's default tablespace.

SQL>execute dbms_aw.aw_create('myaw');

The next command creates an analytic workspace named DEMO in the MYAW_AW schema. AW$DEMO will have two partitions and will be stored in the MYAW tablespace.

SQL>execute dbms_aw.aw_create('myaw_aw.demo', 'myaw', 2);