Oracle® OLAP DML Reference 11g Release 1 (11.1) Part Number B28126-01 |
|
|
View PDF |
The EIFUPDBYTES option controls the frequency of updates when you are using the IMPORT (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 6-31 Reducing Update Frequency
In the following example, the UPDATE keyword in the IMPORT (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