| rbs - urgent [message #55006] |
Thu, 26 December 2002 02:27  |
shareef
Messages: 72
Registered: November 2002
|
Member |
|
|
i have 6 rollback sgements called system,r0,r01,r02,r03,r04.
when i am using exp command, to export database, some time its terminate the exproting in middle and gives error as fallows:
exp-0056 :oracle error 1555 encountered. snapshot too old rollback segment 5 with name r04 too small
the name of the rollback segments in error get changes to r01,r02 and r03 timely.
so i understood that the rollback segments asre too small. but i am not able to desside what to do. either i should delete all these 4 rollback segments and create new 4 roll back segment with huge size of same name or create one or two more new rollback segments by name r05 and r06 to over come with this problem.
and while deleting and creating rollback segment the database should be online or offline?
this presently rollback segments are sized as follows
1 mb size
130 blocks
2 extents
524288 initial extents
524288 next extents
2 min_extents
505 max_extents
0 pct_increase
please any body advice me what to do and kindly also let me know how to do. i really appricate.
thanks to all in advance
|
|
|
|
|
|
|
|
| Re: rbs - urgent [message #55055 is a reply to message #55006] |
Mon, 30 December 2002 13:07  |
Sanjay
Messages: 236
Registered: July 2000
|
Senior Member |
|
|
Since you are getting 'Snapshot too old', it would be better to drop the old rbs and create new ones (bigger)
alter rollback segment r01 offline;
drop rollback segment r01;
create rollback segment r01 tablespace xxx storage (...);
NOTE: Drop all six and create 6 new ones with bigger size.
Later.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
