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 -> Re: flashback query

Re: flashback query

From: <fitzjarrell_at_cox.net>
Date: 24 Jul 2006 12:29:53 -0700
Message-ID: <1153769393.307101.249670@i3g2000cwc.googlegroups.com>

astalavista wrote:
> 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 ???

Probably, as it also works with 9.2.0.6. I'd be patching this installation to at least that release.

David Fitzjarrell Received on Mon Jul 24 2006 - 14:29:53 CDT

Original text of this message

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