Assigning Individual Rollback Segments

Dear All,

we're looking for ways to assign the rollback segments' size to individual users/sessions.
As you know it's possible to increase the general rollback segment size with the Database Expander of the Oracle Database tools (Using Oracle 7.3). But Oracle also assigns individual portions of the rollback segment to each current session/user.
Is there a way to define the size of those individual rollback segments? We need it to enable the users to undo complex transactions as e.g. deleting a customer entry with several hundreds of corresponding orders and invoices.

Any help? Any idea?

Looking forward. Kind regards,

Andreas Wilhelm Received on Fri Aug 08 1997 - 00:00:00 CDT