Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
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.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);
Table B-13 AW_CREATE Procedure Parameters
Parameter | Description |
---|---|
|
The schema that owns 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. |
|
The tablespace in which the analytic workspace is created. If you omit this parameter, the analytic workspace is created in your default tablespace. |
|
The number of partitions that are created for the |
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
has two partitions and is stored in the GLOBAL
tablespace.
EXECUTE dbms_aw.aw_create('global.demo', 'global', 2);