Re: TRIGGER and rollback segment...

You can use this in the trigger or any plsql block:

EXECUTE dbms_transaction.use_rollback_segment('<RBS_NAME>');

+--------------------------------------------------------------------------+

| Vitaliy Mogilevskiy
| Senior Consultant
| CORE Technology Group, Inc.
| E-mail:    vit100gain_at_earthlink.net
| Web Page:  http://home.earthlink.net/~vit100gain/index.html

|            *** Free DBA Script Library at my Web Page ***
+--------------------------------------------------------------------------+

Patrik Stensdahl wrote:

> 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.
Received on Wed Apr 07 1999 - 19:02:12 CDT