DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Set Transaction Use Rollback Segment

Threaded View

  1. #1
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688

    Angry Set Transaction Use Rollback Segment

    Hi all
    Could you pleas have a look the code bellow and tell me please what I am doing wrong? Looks like transaction goes to wrong rollback segment.
    Thanks

    Code:
    SQL> SET TRANSACTION USE ROLLBACK SEGMENT Rollbig;
    
    Transaction set.
    
    SQL> alter table calls drop unused columns;
    alter table calls drop unused columns
    *
    ERROR at line 1:
    ORA-01562: failed to extend rollback segment number 1
    ORA-01650: unable to extend rollback segment R01 by 4 in tablespace RBS
    Oracle 8.1.7.4, Linux RedHat 6.2
    Last edited by kgb; 01-09-2004 at 08:55 AM.
    Best wishes!
    Dmitri

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