Within applications that you created and for which you have Application Manager permissions, you can delete databases.
When you delete a database:
All objects within the database are deleted.
You are asked to unlock locked objects. Locked objects cannot be deleted. Non-administrators can unlock only objects that they locked.
The database directory (ARBORPATH\app\appname\dbname) and all files stored in it are deleted.
Open windows associated with the database (for example, Database Properties, Sessions, and Locks) are closed. For windows that contain unsaved changes, you are asked to save changes.
You can delete one database or all databases on an Essbase Server.
To delete individual databases:
From Enterprise View or a custom view, select a database.
Right-click, and select Delete.
At the confirmation message, click Yes.
If the database contains locked objects, Essbase displays a list of the locked objects and indicates who locked which object at what time.
If the application contains locked objects, unlock objects and complete the delete operation by clicking OK.
Essbase deletes the database, provided that all objects were unlocked, and updates Enterprise View.
To delete all databases on an Essbase Server:
From Enterprise View or a custom view, select the application that contains the databases that you want to delete.
Right-click, and select Delete, and then All databases.
At the confirmation message, click Yes.
If any database contains locked objects, Essbase displays a list of the locked objects and indicates who locked which object at what time.
If the application contains locked objects, unlock objects complete the delete operation by clicking OK.
Essbase deletes all databases for which all locked objects were unlocked and updates Enterprise View.
drop database (MaxL) in the Oracle Essbase Technical Reference
deletedb (ESSCMD) in the Oracle Essbase Technical Reference