AW_ATTACH Procedure

The AW_ATTACH procedure attaches an analytic workspace to your SQL session so that you can access its contents. The analytic workspace remains attached until you explicitly detach it, or you end your session.

AW_ATTACH can also be used to create a new analytic workspace, but the AW_CREATE procedure is provided specifically for that purpose.

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_ATTACH ( 
          awname        IN VARCHAR2,
          forwrite      IN BOOLEAN DEFAULT FALSE,
          createaw      IN BOOLEAN DEFAULT FALSE,
          attargs       IN VARCHAR2 DEFAULT NULL,
          tablespace    IN VARCHAR2 DEFAULT NULL);

AW_ATTACH ( 
          schema        IN VARCHAR2,
          awname        IN VARCHAR2,
          forwrite      IN BOOLEAN DEFAULT FALSE,
          createaw      IN BOOLEAN DEFAULT FALSE,
          attargs       IN VARCHAR2 DEFAULT NULL,
          tablespace    IN VARCHAR2 DEFAULT NULL);

Parameters

Table B-11 AW_ATTACH Procedure Parameters

Parameter	Description
`schema`	The schema that owns awname.
`awname`	The name of an existing analytic workspace, unless createaw is specified as `TRUE`. See the description of createaw.
`forwrite`	`TRUE` attaches the analytic workspace in read/write mode, giving you exclusive access and full administrative rights to the analytic workspace. `FALSE` attaches the analytic workspace in read-only mode.
`createaw`	`TRUE` creates an analytic workspace named awname. If awname already exists, then an error is generated. `FALSE` attaches an existing analytic workspace named awname.
`attargs`	Keywords for attaching an analytic workspace, such as `FIRST` or `LAST`, as described in AW command.

Example

The following command attaches an analytic workspace named MYAW in read/write mode.

SQL>execute dbms_aw.aw_attach('myaw', true);

The next command creates an analytic workspace named MYAW_PROGRAMS in the user's schema. MYAW_PROGRAMS is attached read/write as the last user-owned analytic workspace.

SQL>execute dbms_aw.aw_attach('myaw_programs', true, true, 'last');

This command attaches an analytic workspace named SH from the SH_AW schema in read-only mode.

SQL>execute dbms_aw.aw_attach('sh_aw', 'sh');