SHUTDOWN Procedure

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. 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
`force`	When `YES`, this parameter forces the OLAP session to shutdown even though one or more attached workspaces has not been updated. Default is `NO`.

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();