Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!sn-xit-04!sn-xit-12!sn-xit-09!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: DA Morgan <damorgan@psoug.org>
Newsgroups: comp.databases.oracle.server
Subject: Re: flashback question
Date: Mon, 08 Aug 2005 21:48:28 -0700
Organization: Ye 'Ol Disorganized NNTPCache groupie
Message-ID: <1123552101.311159@yasure>
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
References: <1123539769.035154.185670@g44g2000cwa.googlegroups.com>
In-Reply-To: <1123539769.035154.185670@g44g2000cwa.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Cache-Post-Path: yasure!unknown@67.136.152.196
X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/)
X-Complaints-To: abuse@supernews.com
Lines: 77
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:249149

Eugene wrote:
> Hi all,
> I have a question about flashback. For some reason it doesn't work?!
> Here is what I do:
> 
> show parameter undo_retention;
> NAME                                 TYPE        VALUE
> ------------------------------------ ----------- -----
> undo_retention                       integer     5400
> 
> create table t (varchar2(1));
> Table created.
> 
> select dbms_flashback.get_system_change_number from dual;
> GET_SYSTEM_CHANGE_NUMBER
> ------------------------
>               2927483661
> 
> insert into t values (1);
> 1 row created.
> 
> insert into t values (2);
> 1 row created.
> 
> select dbms_flashback.get_system_change_number from dual;
> GET_SYSTEM_CHANGE_NUMBER
> ------------------------
>               2927483700
> 
> insert into t values(3);
> 1 row created.
> 
> select dbms_flashback.get_system_change_number from dual;
> GET_SYSTEM_CHANGE_NUMBER
> ------------------------
>               2927483714
> 
> commit;
> Commit complete.
> 
> select * from t;
> A
> -
> 1
> 2
> 3
> 
> delete from t;
> 3 rows deleted.
> 
> commit;
> Commit complete.
> 
> select * from t;
> no rows selected
> 
> select * from t as of scn 2927483700;
> select * from t as of scn 2927483700
>               *
> ERROR at line 1:
> ORA-01466: unable to read data - table definition has changed
> 
> ----------------------------------------------
> Why didn't it work??? Did I do something wrong?
> ----------------------------------------------
> 
> Thanks,
> Eugene

Look at the examples at www.psoug.org, Morgan's Library

For flashback query you must have an enabled flashback area.
-- 
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)