Use specific Rollback Segment on remote database

[cardy]

How can I use a specific rollback segment on a remote database. I know I can use the SET TRANSACTION USE ROLLBACK SEGMENT... command but that just sets the local rollback segment. What I'm trying to do is delete from tab@remote_db and I've had to create a large rollback segment (all the others on the remote database are small) but how do I ensure my transaction will use the large rollback segment. (Offlining the small ones or trial & error are NOT an option).

TIA

Cardy

 

[karluk]

Perhaps you have already tried this, but I would try defining a procedure on the remote database. You could set your rollback segment and do the delete within the procedure and then issue a remote procedure call - execute your_proc@remote_db.

 

[cardy]

Thanks. I'll give that a go. I have a feeling it will work.