|Oracle® OLAP DML Reference
11g Release 1 (11.1)
|PDF · Mobi · ePub|
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.
EIFUPDBYTES = n
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
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