Try forcing the load process to be driven from the production site, although it will still be initiated from the staging database:
At the production site, write a stored procedure that will perform the loading process by reading data from the staging database. That way, youŽll be able to use "set transaction use rollback segment tralala; " at the begining of each transaction.
You can call this procedure from your staging database via db_link, so you still have the control of the loading process from that side.
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?