Re: Oracle performance on Large loads.

thielm wrote:

> Does anyone have any experience with loading very large amounts of
> fairly complicated data
> and if so does 140 hours seem normal ? I've tried SQL Loader but because
> of the complexity
> of the relations in one record and the possible relations to other
> records it seems almost

  Two recommendations:
1 disable all database triggers before loading. 2 drop all indices before loading.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841