Re: Flashback Query - Sanpshot Too Old Error

"Prem K Mehrotra" <premmehrotra_at_hotmail.com> wrote in message news:43441e77.0411181346.371091e5_at_posting.google.com...
> premmehrotra_at_hotmail.com (Prem K Mehrotra) wrote in message
news:<43441e77.0411171713.1e148417_at_posting.google.com>...
> > I am using Oracle 9i, 9.2.0.5 on HP UNIX 11.0. I have 2 GB of UNDO
> > table
> > space. When I do a flashback query, I get Snapshot too old error:
> >
> > 1 create table wreports_que_flash
> > 2* as select * from wreports_que as of
> > timestamp(to_timestamp('17-NOV-2004 00:00:00', 'DD-MON-YYYY
> > HH24:MI:SS'))
> > SQL> /
> > as select * from wreports_que as of
> > timestamp(to_timestamp('17-NOV-2004 00:00:00', 'DD-MON-YYYY
> > HH24:MI:SS'))
> > *
> > ERROR at line 2:
> > ORA-01555: snapshot too old: rollback segment number with name "" too
> > small
> > ORA-22924: snapshot too old
> >
> >
> >
> > I do not have much database activity. My undo_retention = 604800
> > which is seven days.
> >
> > I have done flashback queries in the past with success. I don't know
> > why I am getting this error when I am only accessing a few hours ago
> > of data.
> >
> > Any ideas will be helpful.
> >
> > Thanks a lot,
> >
> > Prem
>
> Any ideas?
>
> rem

Your UNDO tablespace is too small

Matthias Received on Thu Nov 18 2004 - 16:12:46 CST