Oracle® OLAP DML Reference 10g Release 1 (10.1) Part Number B10339-02 |
|
|
View PDF |
The EIFEXTENSIONPATH option contains a list of directory objects that identify the locations where EIF extension files should be created.
Data type
TEXT
Syntax
EIFEXTENSIONPATH = path-expression
Arguments
A text expression that contains one or more directory object names. When you specify multiple aliases, you must enter each one on a separate line. Specify multiple aliases in the order in which they should be used for storing EIF extension files.
Notes
When the size of an EIF file grows beyond the size specified for EIF files by the FILESIZE argument to the EXPORT (to EIF) command, or the current disk or location becomes full, an EIF extension file is created.
Before creating a new extension file, the location specified by EIFEXTENSIONPATH is checked for sufficient disk space. The required amount of disk space is the amount specified for FILESIZE in the EXPORT (to EIF). When no value has been specified for FILESIZE, then a check is made for at least 80K of disk space (the minimum size allowed by FILESIZE). When there is insufficient disk space, checking continues through the list until a location with enough available disk space is found.
When EIFEXTENSIONPATH contains multiple directory objects, the first extension file is created in the first alias in the list. The second extension file is created in the second alias on the list, and so on. When the end of the list is reached, the process starts over again at the beginning. When EIFEXTENSIONPATH contains a single directory object, all extension files are created in that location.
When specifying files and directories in OLAP DML statements, it is good practice to always enclose them in single quotes.
Examples