AW_UPDATE Procedure

The AW_UPDATE procedure saves the changes made to an analytic workspace in its permanent database table. For the updated version of this table to be saved in the database, you must issue a SQL COMMIT statement before ending your session.

If you do not specify an analytic workspace to update, AW_UPDATE updates all the user-defined workspaces that are currently attached 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_UPDATE ( 
          awname     IN VARCHAR2 DEFAULT NULL);

AW_UPDATE ( 
          schema     IN VARCHAR2 DEFAULT NULL,
          awname     IN VARCHAR2 DEFAULT NULL);

Parameters

Table B-18 AW_UPDATE Procedure Parameters

Parameter	Description
`schema`	The schema that owns awname.
`awname`	Saves changes to awname by copying them to a table named `AW$`awname. If this parameter is omitted, then changes are saved for all analytic workspaces attached in read/write mode.

Example

The following commands save changes to the GLOBAL analytic workspace from the temporary to the permanent tablespace, then commit the change to the database.

EXECUTE dbms_aw.aw_update('global');
COMMIT;