-
I am having a problem when I try to use:
SET TRANSACTION USE ROLLBACK SEGEMENT RB7
delete from results_storage_history
where result_time <= to_date('01-FEB-02', 'DD-MON-YY');
commit;
I keep getting error message saying that "delete from results_storage_history" was not properly ended. However when I do not use the SET Transaction command it runs and I get rollback too small errors.
Any ideas? Thanks
-
Never mind
[Edited by Mr.Hanky on 02-12-2002 at 12:30 PM]
-
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
-
-
You must perform a commit before to use the set transaction use rollback segment ...
Regards
Angel