Change details about a tablespace. Tablespaces are applicable only to aggregate storage databases.
To see a list of tablespaces, use display tablespace. You cannot change the location or size of the
metadata
and log
tablespaces.
Permission required: Application designer. This statement requires the application to be started.
alter tablespace asosamp.'default' add file_location 'C:\\mytablespace' set max_file_size 50mb;
Adds another file location for thedefault
tablespace. Now the tablespacedefault
is inC:\mytablespace
in addition to the original location,C:\Hyperion\essbase\APP
.
alter tablespace asosamp.'default' alter file_location 'C:\\Hyperion\\essbase\\APP\\' set max_file_size 50mb;
Changes the maximum file size allowed in the specified location of the default tablespace. Note that the file_location string is case sensitive.
Use alter tablespace to edit tablespaces in the following ways:
Key Phrase | Explanation |
---|---|
add file_location | Add a new file location to the tablespace.
Note: FILE-NAME is case sensitive in this statement. |
alter file_location | Change the maximum file-size or disk-size value for the
specified file location.
Note: FILE-NAME is case sensitive in this statement. |
set max_file_size |
Specify a value for the maximum size that a
data file may attain before Analytic Services creates a new file.
The largest possible value that the aggregate storage kernel can handle is 134217727 MB. This is also the default value. 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 134217727 MB, the kernel ignores the setting and caps file size at 134217727 MB. The minimum value is 8MB (8388608b), and any values you enter are rounded up to the next 8MB interval. |
set max_disk_size | Specify the value for the maximum amount of disk space to be allocated to
the file location.
The largest possible value that the aggregate storage kernel can handle is 4294967295 MB. This is also the default value. 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 4294967295 MB, the kernel ignores the setting and caps disk size at 4294967295 MB. The minimum value is 8MB (8388608b), and any values you enter are rounded up to the next 8MB interval. |
drop file_location | Delete the specified 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.
Note: FILE-NAME is case sensitive in this statement. |
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |