Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!l41g2000cwc.googlegroups.com!not-for-mail From: "Mark D Powell" Newsgroups: comp.databases.oracle.server Subject: Re: Need help with oracle 9i Date: 2 Feb 2005 08:46:24 -0800 Organization: http://groups.google.com Lines: 8 Message-ID: <1107362784.039847.226110@l41g2000cwc.googlegroups.com> References: <1107356407.703512.142110@g14g2000cwa.googlegroups.com> <1107358858.280757.289560@g14g2000cwa.googlegroups.com> NNTP-Posting-Host: 192.85.50.1 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1107362788 24141 127.0.0.1 (2 Feb 2005 16:46:28 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 2 Feb 2005 16:46:28 +0000 (UTC) In-Reply-To: <1107358858.280757.289560@g14g2000cwa.googlegroups.com> User-Agent: G2/0.2 Complaints-To: groups-abuse@google.com Injection-Info: l41g2000cwc.googlegroups.com; posting-host=192.85.50.1; posting-account=J7QqBQwAAABTieek3RP_669Gs2iATWzr Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:234812 I need to retract the 10g feature statement. Flashback query was introduced in version 9i and expanded in 10g. Using an imp of an exp .dmp file still stands as a possible solution as since flashback query is only available if an undo tablespace is in use rather than traditional rollback segments. HTH -- Mark D Powell --