If you have Application Manager permissions for a database, you can rename that database. If any objects within the database are locked by other users, Essbase prompts you to remove the locks before deleting. Unless you are an Administrator, you can unlock only those objects that you originally locked.
When you rename a database, the database directory (ARBORPATH\app\appname\dbname) and database outline (dbname.otl) are renamed. Other system-defined database files are also renamed (dbname.db, dbname.dbb, dbname.esm, dbname.ind, dbname.tct).
Database objects created separately from the database, such as calculation scripts and report scripts, are not renamed.
To rename a database:
From Enterprise View or a custom view, select the database.
Right-click and select Rename.
In the Rename Database dialog box, enter the new name for the database. (For naming restrictions, see the Oracle Essbase Database Administrator's Guide.)
Click OK.
If the database contains objects that are locked, Essbase displays a list of these objects and indicates who locked the object at what time.
To unlock objects and complete the rename operation, click OK. If all objects are unlocked successfully, Essbase renames the database and updates Enterprise View.
alter database (MaxL) in the Oracle Essbase Technical Reference
renamedb (ESSCMD) in the Oracle Essbase Technical Reference