Bulk load is supported for Oracle9i R2 and higher with the following limitations.

  • A bulk operation is not allowed in a manual transaction if it is not the first event.
  • Once a bulk operation is started, any non-bulk operation is disallowed until the transaction is committed.
  • Because of Oracle limitations, issuing a SELECT statement to determine a row count may return different results before and after a bulk load operation.
  • Native bulk insert operations are not supported on views.
  • The operation INSERT INTO ... SELECT ... is not supported by the bulk load API.
  • Oracle does not support literal values in a bulk load operation. You must use parameter markers for all columns being loaded.