Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> rollback segment problem

rollback segment problem

From: <daud11_at_hotmail.com>
Date: Mon, 17 May 1999 07:25:33 GMT
Message-ID: <7hog9b$3p$1@nnrp1.deja.com> 





Hi All



I have a query which always fail with the following msg: Oracle Error 1555:
ORA 01555: Snapshot too old: Rollback segment .... too small.



What should I do? I have tried to increase the optimal size to 15M from 10M
for all the rollback segments but still does not solve the problem.



Any advice?



Daud



-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own    
Received on Mon May 17 1999 - 02:25:33 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US