How to enable direct path load with the forall insert construct in 11.2.0.2?
The code that loads the table is the following
forall Ix in indices of Recs save exceptions
insert into Bas_job
values Recs (Ix);
In 11.2 there is a new hint APPEND_VALUES that is supposed to enable direct path load when using the insert ... values construct. When I apply this hint to the above code, it fails with
ORA-38910: BATCH ERROR mode is not supported for this operation.