Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-02 |
|
|
View PDF |
The EIFUPDBYTES option controls the frequency of updates when you are using the IMPORT (from EIF) command with its UPDATE keyword. The value of EIFUPDBYTES has an effect only when the UPDATE keyword is specified in this command.
Data type
INTEGER
Syntax
EIFUPDBYTES = n
Arguments
An INTEGER
expression that specifies the minimum number of bytes to be read between updates, during an import. When EIFUPDBYTES has a value of 0, an update is triggered after each analytic workspace object is imported. When EIFUPDBYTES has a value greater than 0, an update is triggered each time the specified number of bytes is imported. The default is 0
(zero).
Examples
Example 13-23 Reducing Update Frequency
In the following example, the UPDATE keyword in the IMPORT (from EIF) command ensures that updates will occur periodically. The setting of EIFUPDBYTES ensures that the updates will not occur too often.
EIFUPDBYTES = 500000 IMPORT ALL FROM EIF FILE 'finance.eif' UPDATE