Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!o13g2000cwo.googlegroups.com!not-for-mail
From: dbaplusplus@hotmail.com
Newsgroups: comp.databases.oracle.server
Subject: Re: flashback question
Date: 8 Aug 2005 19:50:21 -0700
Organization: http://groups.google.com
Lines: 14
Message-ID: <1123555821.712171.217240@o13g2000cwo.googlegroups.com>
References: <1123539769.035154.185670@g44g2000cwa.googlegroups.com>
   <1123552101.311159@yasure>
NNTP-Posting-Host: 148.177.1.213
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1123555829 2094 127.0.0.1 (9 Aug 2005 02:50:29 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 9 Aug 2005 02:50:29 +0000 (UTC)
In-Reply-To: <1123552101.311159@yasure>
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: o13g2000cwo.googlegroups.com; posting-host=148.177.1.213;
   posting-account=Rsc_ew0AAADekMIc-dc4fPwmaOlJ6nox
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:249158

>> For flashback query you must have an enabled flashback area

Not sure, what do you mean here? I am assuming one is talking about
Oracle 10G which introduced
flashback recovery area? It is my understanding that only flashback
database feature requires flashback recovery area
where flashback logs are kept.

However, flashback query, flashback table etc only require automatic
undo management (undo tablespace). Flashback query has been available
since Oracle9i which did not have flashback recovery area.

Please clarify, if I misunderstood you?