Sunitha

• May 12th, 2006

 

Conventional Load: 
Before loading the data, all the Table constraints will be checked against the data. 
 
Direct load:(Faster Loading) 
All the Constraints will be disabled. Data will be loaded directly.Later the data will be checked against the table constraints and the bad data won't be indexed.

Api conventional loading

utility direct loading.

dontbuckme

 Profile Answers by dontbuckme 

• Sep 22nd, 2006

 

Mis-conception!

Utility Mode can be either Direct or Conventional.

This question is basically an Oracle question, details please refer to the Oracle sqlldr references.

Conventional Load:  same as doing "INSERT INTO" statement.  Data will go thru the SQL area, all database/table triggers will be fired, all table constraints will be checked.  Indexes will be maintained online.

Direct Load: data directly written to the data blocks, no use of buffer cache, can load to a specific table partition, some constraints are checked, index "might" be disabled (depends on the layout), need to specify native options for "skip index maintenances".