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.

Makes sence?