Clearing All Data from an Aggregate Storage Database
Clearing all data from an aggregate storage database is the same as for a block storage database. To clear the entire database, either use:
The alter database MaxL statement with the reset grammar:
alter database appname.dbname reset;
Administration Services Console
See “Clearing Data” in the Oracle Essbase Administration Services Online Help.