Return
-
Title
When using the import wizard with Excel files and an Oracle connection, the process do the import every 5-7 rows -
Description
The Oracle database connection can be configured as a Direct connection or as an Oracle client (OCI) connection.
When the Oracle connection has been configured as a Direct connection, the import wizard of big Excel files do the process every 5-7 rows.
-
Cause
- The Oracle client (OCI) connection has better performance than the Oracle Direct connection.
- Option Optimize the block size has been selected.
-
Resolution
WORKAROUND 1:
Un-check the option "Optimize block size" and specify the Processing row count. By default, the Processing row count value is 2000.
WORKAROUND 2:
When working with Direct connections to the Oracle databases, create the connection using an Oracle client.