Adriano dos Santos Fernandes wrote:

> Pavel Cisar wrote:
>
>> 2. Good bulk load solution should also provide automatic handling of
>> deferred index updates (at least for user defined ones) and ability to
>> disable triggers on updated tables.
>>
> If a table has a trigger, I suspected it was not created to make things
> slow.
>
> Why one will need to disable triggers?
>

If you are load data from another system or reloading archive data, you
don't want triggers fired.

> This make implementation complicated, as that will require SYSDBA/owner
> rights to do this.
>
>

Of course.