Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news-out.cwix.com!pullfeed!newsfeed.cwix.com!newsfeed.icl.net!newsfeed.fjserv.net!kibo.news.demon.net!news.demon.co.uk!demon!not-for-mail From: "Jonathan Lewis" Newsgroups: comp.databases.oracle.server Subject: Re: Oracle table snapshot Date: Sun, 2 Feb 2003 19:15:33 -0000 Lines: 53 Message-ID: References: <4f0df91b.0302012129.34d529d9@posting.google.com> NNTP-Posting-Host: jlcomp.demon.co.uk X-Trace: news.demon.co.uk 1044213334 27674 158.152.75.41 (2 Feb 2003 19:15:34 GMT) X-Complaints-To: abuse@demon.net NNTP-Posting-Date: Sun, 2 Feb 2003 19:15:34 +0000 (UTC) X-MIMEOLE: Produced By Microsoft MimeOLE V4.72.3110.3 X-Newsreader: Microsoft Outlook Express 4.72.3110.5 Xref: newsfeed1.easynews.com comp.databases.oracle.server:174515 X-Received-Date: Sun, 02 Feb 2003 12:14:53 MST (news.easynews.com) Good point about versions - yes, this trick will only work with 9.2. Although you can do something vaguely similar with 9.0 it's no more convenient than running 'create table as select' before running the tests, and then doing the UNION ALL of MINUSes. NB I don't LIKE flashback - but that doesn't mean I can't suggest it to someone else. -- Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) ____UK_______March 19th ____USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) ____USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Howard J. Rogers wrote in message ... >Hi Jonathan... > >Not only do you need 9, you actually need 9i R2 (correct me if I'm wrong) >because the 'as of' syntax only became available then. > >Nice to know incidentally that you like Flashback, albeit only in >development! > >Regards >HJR >