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

2002-01-15 Thread Viktor
Hi all, Last nignt when we were expring data for one of our databases, this error ocurred: ORA-01555: snapshot too old: rollback segment number 3 with name R02) offset=(0). Now, we were able to once again export and load data this morning. And there was no error. What is the best aproach

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

2002-01-15 Thread Babich , Sergey
Subject:ORA-01555: snapshot too old: rollback segment number... Hi all, Last nignt when we were expring data for one of our databases, this error ocurred: ORA-01555: snapshot too old: rollback segment number 3 with name R02) offset=(0). Now, we were able to once again export and load data

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

2002-01-15 Thread Karniotis, Stephen
: rollback segment number... Hi all, Last nignt when we were expring data for one of our databases, this error ocurred: ORA-01555: snapshot too old: rollback segment number 3 with name R02) offset=(0). Now, we were able to once again export and load data this morning. And there was no error

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

2002-01-15 Thread
of list ORACLE-L Subject: ORA-01555: snapshot too old: rollback segment number... Hi all, Last nignt when we were expring data for one of our databases, this error ocurred: ORA-01555: snapshot too old: rollback segment number 3 with name R02) offset=(0). Now, we were able

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

2002-01-15 Thread Rachel Carmichael
To: Multiple recipients of list ORACLE-L Subject:ORA-01555: snapshot too old: rollback segment number... Hi all, Last nignt when we were expring data for one of our databases, this error ocurred: ORA-01555: snapshot too old: rollback segment number 3 with name R02) offset=(0

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