Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
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"AW_UPDATE ( awname IN VARCHAR2 DEFAULT NULL);
AW_UPDATE ( schema IN VARCHAR2 DEFAULT NULL, awname IN VARCHAR2 DEFAULT NULL);
Table B-18 AW_UPDATE Procedure Parameters
Parameter | Description |
---|---|
|
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;