Oracle® OLAP DML Reference 11g Release 1 (11.1) Part Number B28126-02 |
|
|
View PDF |
The SHUTDOWN
procedure terminates the current OLAP session.
By default, the SHUTDOWN
procedure terminates the session only if there are no outstanding changes to any of the attached read/write workspaces. If you want to terminate the session without updating the workspaces, specify the force
parameter.
Note:
You cannot execute this procedure from within the OLAP Worksheet. You must execute if in a SQL tool such as SQL*Plus.Syntax
SHUTDOWN ( force IN BOOLEAN DEFAULT NO);
Parameters
Table B-29 SHUTDOWN Procedure Parameters
Parameter | Description |
---|---|
|
When |
Example
The following commands save all changes to the GLOBAL
analytic workspace and close the user's OLAP session.
EXECUTE dbms_aw.aw_update('global_finance'); COMMIT; EXECUTE dbms_aw.shutdown();