AW_COPY Procedure

The AW_COPY procedure copies the object definitions and data from one analytic workspace into a new analytic workspace.

AW_COPY detaches the original workspace and attaches the new workspace first with read/write access.

Note:

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

See also:

"Managing Analytic Workspaces"

Syntax

AW_COPY ( 
          oldname         IN VARCHAR2,
          newname         IN VARCHAR2,
          tablespace      IN VARCHAR2 DEFAULT NULL,
          partnum         IN NUMBER DEFAULT 8);

Parameters

Table B-12 AW_COPY Procedure Parameters

Parameter	Description
`oldname`	The name of an existing analytic workspace that contains object definitions. The workspace cannot be empty.
`newname`	A name for the new analytic workspace that is a copy of oldname.
`tablespace`	The name of a tablespace in which newname will be stored. If this parameter is omitted, then the analytic workspace is created in the user's default tablespace.
`partnum`	The number of partitions that will be created for the `AW$`newname table.

Example

The following command creates a new analytic workspace named DEMO and copies the contents of MYAW into it. The workspace is stored in a table named AW$DEMO, which has three partitions and is stored in the user's default tablespace.

SQL>execute dbms_aw.aw_copy('myaw', 'demo', null, 3);