RBS for Distributed transaction

The system I work on has a staging database and a production database.

Data is inserted into the production database with a link from the staging database.

The activity on the production database is small except for these updates. Thus, I want several small RBS's and one big RBS for large updates.

The data is inserted or updated from staging instead of selected from production. That means that the developers cannot set the RBS for the transaction. Otherwise, we could use

set transaction use rollback segment tralala;

Does anyone have a trick to set the RBS in a distributed transaction?

Thanks in advance.

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?