-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|