Re: TRIGGER and rollback segment...

Patrik Stensdahl wrote in message <7ef5ft$arm1_at_ftp.kvaerner.com>...
>Is it possible to assign a trigger to use a specific rollback segment?
>
>The command "SET TRANSACTION USE ROLLBACK SEGMENT RB..."
>isnīt allowed to be used in a trigger.
>
>

In Oracle 7, this is not possible. The reason is that a transaction uses only one rollback segment, and the transaction is already initiated when the trigger fires.

I don't know whether it is possible in Oracle 8.

Regards,

Roy Brokvam
roy.brokvam_at_conax.com Received on Wed Apr 07 1999 - 03:36:16 CDT