Problem with SET TRANSACTION USE...

[Mr.Hanky]

Try this

SQL> set transaction use rollback segment rbs0102;

Transaction set.

SQL> delete from emp where
2 hiredate<= to_date('01-FEB-02', 'DD-MON-YY');

1 row deleted.

it is two seperate staements

MH