Database Tuning (MOSC)

MOSC Banner

How to enable direct path load with the forall insert construct in 11.2.0.2?

edited May 23, 2011 4:45PM in Database Tuning (MOSC) 2 commentsAnswered ✓
 I am loading a large table (106 million rows) from scratch on 11.2.0.2. The table is a good candidate for direct path load (it is only loaded, then read, no other dml), no constraints except a primary key.

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center