AW TRUNCATE

Deletes all of the objects and data from an existing analytic workspace. Oracle also deallocates all of the table space used by the analytic workspace.Removing data using AW TRUNCATE can be more efficient and less "destructive" than deleting an analytic workspace using AW DELETE. For example, when you remove data using AW TRUNCATE, all of the object privileges that were previously granted remain. For more information on truncating a table, see the TRUNCATE statement in Oracle Database SQL Reference.

Syntax

AW TRUNCATE workspace

Arguments

workspace: The name of the analytic workspace. You must specify the name; you cannot specify an alias.

Examples

Removing all Data from a Workspace

You can use the AW command with the TRUNCATE keyword to delete all of the objects and data in a workspace.

AW DELETE mywork