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"
AW_UPDATE ( awname IN VARCHAR2 DEFAULT NULL);
AW_UPDATE ( schema IN VARCHAR2 DEFAULT NULL, awname IN VARCHAR2 DEFAULT NULL);
The schema that owns awname.
Saves changes to awname by copying them to a table named
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;