RE: ORA-01555: snapshot too old: rollback segment number...

2002-01-15 Thread Babich , Sergey
Hi, Viktor, Have any long transactions been running parallel to the export when it happened? And do you specify the parameter CONSISTENT=Y for the export? Regards,, Sergey Babich -Original Message- Sent: Tuesday, January 15, 2002 12:20 PM To: Multiple recipients of list ORACLE-L

RE: ORA-01555: snapshot too old: rollback segment number...

2002-01-15 Thread Karniotis, Stephen
You can export with CONSISTENT=N; a consistent view of the data will not be achieved. You can also increase the size of your rollback segments to accommodate large queries while updates are being performed. There is not much else you can do on this one. Thank You Stephen P. Karniotis

RE: ORA-01555: snapshot too old: rollback segment number...

2002-01-15 Thread
on this error (if I remember correctly) Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Karniotis, Stephen [SMTP:[EMAIL PROTECTED]] Sent: Tue, January 15, 2002 8:05 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-01555: snapshot too

RE: ORA-01555: snapshot too old: rollback segment number...

2002-01-15 Thread Rachel Carmichael
correctly) Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Karniotis, Stephen [SMTP:[EMAIL PROTECTED]] Sent: Tue, January 15, 2002 8:05 PM To: Multiple recipients of list ORACLE-L Subject:RE: ORA-01555: snapshot too old: rollback

RE: ORA-01555: snapshot too old: rollback segment number...

2002-01-15 Thread Deshpande, Kirti
, Stephen [SMTP:[EMAIL PROTECTED]] Sent: Tue, January 15, 2002 8:05 PM To: Multiple recipients of list ORACLE-L Subject:RE: ORA-01555: snapshot too old: rollback segment number... You can export with CONSISTENT=N; a consistent view of the data will not be achieved. You can also

RE: ORA-01555: snapshot too old: rollback segment number...

2002-01-15 Thread Viktor
Subject: RE: ORA-01555: snapshot too old: rollback segment number... You can export with CONSISTENT=N; a consistent view of the data will not be achieved. You can also increase the size of your rollback segments to accommodate large queries while updates are being