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 -> ORA-01555: snapshot too old: rollback segment number 2 with name "R01" too small

ORA-01555: snapshot too old: rollback segment number 2 with name "R01" too small

From: krishna <s_venkatakrishna_at_hotmail.com>
Date: 21 Feb 2003 00:50:20 -0800
Message-ID: <8cdd702b.0302210050.6bc02abd@posting.google.com> 





Guys,



I am getting the above when I am importing from
a view. I have a .sql file running through unix shell script.



I Understand that I have to increase the ROLLBACK Segment size. 
Where should I do this / run this from ? In my script? or has to be
done at DBA level?



Please help me.



Cheers,


krish
Received on Fri Feb 21 2003 - 02:50:20 CST












Original text of this message













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