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 -> Flashback Query - Sanpshot Too Old Error

Flashback Query - Sanpshot Too Old Error

From: Prem K Mehrotra <premmehrotra_at_hotmail.com>
Date: 17 Nov 2004 17:13:32 -0800
Message-ID: <43441e77.0411171713.1e148417@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 Received on Wed Nov 17 2004 - 19:13:32 CST

Original text of this message

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