![]() Previous |
![]() Next |
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 TRUNCATE TABLE in Oracle Database SQL Language Reference.
Note: Before you can truncate an analytic workspace in a schema that you do not own, you need the appropriate SQL GRANT privilege as outlined in "Privileges Needed to Create and Delete Analytic Workspaces". |
Syntax
AW TRUNCATE workspace
Parameters
The name of the analytic workspace. You must specify the name; you cannot specify an alias.
Examples