Statements for Managing Analytic workspaces


Table: Statements for Creating and Managing Analytic Workspaces lists the OLAP DML statements that you use to create and manage analytic workspaces.

Statements for Creating and Managing Analytic Workspaces

Statement Description
AW command
Creates a new workspace; attaches a workspace to a session; deletes a workspace; detaches a workspace from a session; sets up a workspace for multiple segments; or sends to the current outfile a list of the active workspaces, along with their update status.
COMMIT
Executes a SQL COMMIT statement.
UPDATE
Moves analytic workspace changes from a temporary area to the database table in which the workspace is stored. The table is not saved until you execute a COMMIT command, either from Oracle OLAP or from SQL.