-
Hi,
When Issuing an update statement I am getting the following error
ERROR at line 1:
ORA-01562: failed to extend rollback segment number 5
ORA-01650: unable to extend rollback segment RB2 by 32 in tablespace RBS
The Rollback segment is as follows
RBS - TableSpace - Initial =1M, Next = 1M Maximum value = unliminted
RBS Datafile = Size = 500MB (Used = 4MB)
Rollback segments = RB0 , RB01,RB02,RB03,RB04,RB05,RB06,RB07
For all of them
(Extents )Initial = 256K,Next = 256K, Optimal = 512K
Minimum Number = 2, Maximum Number = 32765
As I see there is a lot of space to extend then why is it giving the error
Thanks
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
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
|