Restrictions

Data load using parallel index updates optimization is unavailable in certain scenarios.

You cannot use data-load optimization:

The following behaviour and restrictions are imposed when bulk insert is used in a transaction:

Serial or concurrent data that is loaded using bulk inserts in a multistatement transaction is visible only to the inserting task while the transaction is active. While the transaction that loaded this data using bulk inserts remains active, concurrent access to this data by other tasks skips the uncommitted data.
A single transaction can perform multiple bulk inserts to the same table multiple times. However, in a single transaction (whether it spans multiple databases, or only one), you can insert into a maximum number of four tables per database using this optimization.
Bulk inserts are not applied to the fifth and subsequent tables in one transaction, and data load is performed in non-bulk mode, with serial index updates.
Bulk insert is disabled while the following commands are underway concurrently when the data load is attempted. The insert instead performs in non-bulk mode, with serial index updates.
- reorg rebuild ... with online
- create index ... with online
If the ddl in tran database option is enabled, an attempt to execute create index ...with online on a table following an insert bulk to that table in the same transaction is restricted. The create index operation is aborted, but the transaction remains active.