Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Flashback Query - Sanpshot Too Old Error
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'))
*
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