Location aliases map database alias names to the physical locations of the databases. If you have Database Manager permissions, you can edit location alias definitions and delete location aliases.
Note: | This functionality does not apply to aggregate storage databases. |
To edit or delete location aliases:
From Enterprise View or a custom view, select a database.
Right-click, and select Edit, and then Location aliases.
In the Location Aliases window, perform one or both actions:
Edit alias information, and click Set.
For an alias, select a row, and click Delete.
drop location alias (MaxL) in the Oracle Essbase Technical Reference
deletelocation (ESSCMD) in the Oracle Essbase Technical Reference