flashback query

From: astalavista <nobody_at_nowhere.com>
Date: Mon, 24 Jul 2006 21:22:00 +0200
Message-ID: <44c51dd3$0$32179$636a55ce@news.free.fr>

Hi,

I try to use flashback query on 9.2.0.4/ AIX 5.1

I get always the following error

SQL> select owner from toto AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '8' MINUTE) ;
select owner from toto AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '8' MINUTE)

                  *

ERROR at line 1:
ORA-08176: consistent read failure; rollback data not available

SQL> sho parameter undo

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------- 
undo_management                      string      AUTO
undo_retention                       integer     10800
undo_suppress_errors                 boolean     FALSE
undo_tablespace                      string      UNDOTBS

I am sure to have my data in the UNDO

( I tried this on 10.2, and it works ...)

Any bug ??? Received on Mon Jul 24 2006 - 14:22:00 CDT