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');
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