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.