You use the Tablespaces tab of the Application Properties window to set properties for tablespaces used for physical storage for aggregate storage applications.
This window contains two tabs, one for each system-defined tablespace (default and temp).
File Location—Enter the full path to an existing directory where data files will be stored.
If Essbase Server is running on a UNIX platform, this path is case-sensitive.
You cannot edit this column for existing file locations.
Max Disk Size—Specify the maximum amount of disk space to be allocated to the file location.
For new file locations, you can specify a value or select Unlimited. The Unlimited value for disk size represents the largest possible value that the aggregate storage kernel can handle. If operating system limits take effect before this value is reached, the kernel attempts to use another file location in the tablespace. If you enter a value that is larger than the Unlimited value, the kernel ignores the setting. The initial system-defined file location also uses the Unlimited value.
Unit—Select the unit for the Max Disk Size, MB or GB.
Max File Size—Specify the maximum data file size before Essbase creates a new file.
For new file locations, you can specify a value or select Unlimited. The Unlimited value for file size represents the largest possible value that the aggregate storage kernel can handle. If operating system limits take effect before this value is reached, the kernel creates a new file. If you enter a value that is larger than the Unlimited value, the kernel ignores the setting. The initial system-defined file location also uses the Unlimited value.
Unit—Select the unit for the Max File Size, MB or GB.
Add Location—Click to add a new file location to the tablespace.
Drop Location—Click to delete the selected file location from the tablespace. When a file location is deleted, all files in the file location are deleted, as well as the subdirectory containing the files.
You cannot delete a file location if it contains data. You cannot delete the tablespace itself.
“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
query application (MaxL) in the Oracle Essbase Technical Reference