When do you use Normal Loading and the Bulk Loading, Tell the difference?

  • Interview Candidate
  • 9
  • 2204

Showing Answers 1 - 9 of 9 Answers

rama krishna

  • Sep 19th, 2007
 

If we use SQL Loder connections then it will be to go for Bulk loading. And if we use ODBC connections for source and target definations then it is better to go for Normal loading.
If we use Bulk loading then the session performence will be increased.
how means... if we use the bulk loading, the data will be BYPASS through the DATALOGS. So automatically performence will be increased.

  Was this answer useful?  Yes

chandrarekha

  • Sep 28th, 2007
 

Normal Load: It loads the records one by one, Server writes log file for each record, So it takes more time to load the data.

Bulk load : It loads the number of records at a time, it does not write any log files or tracing levels, so it takes less time.

vivekvish

  • Jul 24th, 2008
 

You would use Normal Loading when the target table is indexed and you would use bulk loading when the target table is not indexed. Running Bulk Load in an indexed table will cause the session to fail.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions