Skip Headers
Oracle® OLAP DML Reference
11g Release 1 (11.1)

B28126-03
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
PDF · Mobi · ePub

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 GLOBAL_FINANCE. The new analytic workspace is stored in a table named AW$GLOBAL_FINANCE with eight partitions in the user's default tablespace.

EXECUTE dbms_aw.aw_create('global_finance');

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

EXECUTE dbms_aw.aw_create('global.demo', 'global', 2);