There is an internal table called user_triggers
this will hold all the triggers pertains to your schema.
just build a sql like this
select 'alter table '|| table_name||' disable all triggers ; '
from user_triggers;
spool this output to a file and execute.
Once bulk loading is complete,
build the same script to enable it.
that's it.




Reply With Quote