Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g44g2000cwa.googlegroups.com!not-for-mail
From: "robyn.sands@gmail.com" <robyn.sands@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: flashback question
Date: 8 Aug 2005 15:33:42 -0700
Organization: http://groups.google.com
Lines: 10
Message-ID: <1123540422.064641.92280@g44g2000cwa.googlegroups.com>
References: <1123539769.035154.185670@g44g2000cwa.googlegroups.com>
NNTP-Posting-Host: 192.133.192.1
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1123540427 14339 127.0.0.1 (8 Aug 2005 22:33:47 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 8 Aug 2005 22:33:47 +0000 (UTC)
In-Reply-To: <1123539769.035154.185670@g44g2000cwa.googlegroups.com>
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: g44g2000cwa.googlegroups.com; posting-host=192.133.192.1;
   posting-account=MbPuTQ0AAACCbfXW1SiTCWziQjgL-ef9
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:249139

When I use flashback, I use something like this:

execute dbms_flashback.enable_at_system_change_number(2927483700);

select * from t;   (should show you three rows of data in your example)

execute dbms_flashback.disable;   (to revert to 'real' data)

Robyn