Problem with SET TRANSACTION USE...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Problem with SET TRANSACTION USE...

  1. #1
    Join Date
    Jan 2002
    Posts
    36
    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

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    Never mind

    [Edited by Mr.Hanky on 02-12-2002 at 12:30 PM]
    I remember when this place was cool.

  3. #3
    Join Date
    Jan 2001
    Posts
    3,131
    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
    I remember when this place was cool.

  4. #4
    Join Date
    Jan 2002
    Posts
    36
    thanks.....it worked!

  5. #5
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    You must perform a commit before to use the set transaction use rollback segment ...

    Regards

    Angel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width