Essbase uses tablespaces to optimize data storage and retrieval for aggregate storage data files and work files. Tablespaces are location definitions that map data objects, such as aggregate views and aggregations, to files.
Essbase sets up two tablespaces that cannot be altered (log and metadata) and two tablespaces that can be altered (default and temp). You can change the size and location of the default and temp tablespaces, but you cannot remove or rename them. Within all four tablespaces, data is stored in file locations. You can modify internal file locations and can delete file locations that do not contain data.
To manage tablespaces for aggregate storage applications:
From Enterprise View or a custom view, select an application.
Right-click, and select Edit properties.
In the Application Properties window, select the Tablespaces tab.
Perform one or more actions:
To add a file location to a tablespace, click Add Location, and enter the path and parameters.
To edit a file location, click in a cell, and modify parameters.
Note:
You cannot edit file-location paths.
To remove a file location from a tablespace, select a row, and click Drop Location.
Click Apply.
“Managing Storage for Aggregate Storage Applications” in the Oracle Essbase Database Administrator's Guide
alter tablespace (MaxL) in the Oracle Essbase Technical Reference
display tablespace (MaxL) in the Oracle Essbase Technical Reference