AW FREEZE

The AW FREEZE command commits the current transaction (if any) and sets a flag that specifies that the analytic workspace is the default attach version of the workspace. Later, when a request is made to attach the workspace in read only or read multi mode, Oracle OLAP attaches this flagged generation of the analytic workspace.

Note:

You must be attached to the analytic workspace in one of the write modes to execute this command.

Syntax

AW FREEZE [NOTHAW]

Arguments

NOTHAW

Specifies that you cannot specify the THAW keyword with AW ATTACH when you attach the workspace at a later time.

Note:

Once an analytic workspace is frozen, attaching an analytic workspace in read mode attaches the analytic workspace as of the frozen generation unless you specify the THAW keyword with the AW ATTACH command.

Notes

Freezing an Analytic Workspace

Keep the following points in mind when freezing an analytic workspace:

Only one generation of an analytic workspace can be frozen at a time
You cannot refreeze a currently frozen analytic workspace without first thawing it using the AW THAW command.

Example

No example for beta.