From: "Paul Brewer" <paul@paul.brewers.org.uk>
Newsgroups: comp.databases.oracle.server
References: <4f0df91b.0302012129.34d529d9@posting.google.com> <b1jn8o$mh6$1$8302bc10@news.demon.co.uk> <End%9.38997$jM5.99057@newsfeeds.bigpond.com> <b1jqom$r0q$1$8302bc10@news.demon.co.uk>
Subject: Re: Oracle table snapshot
Date: Sun, 2 Feb 2003 20:20:44 -0000
Lines: 67
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: ppp-0-47.lond-a-3.access.uk.tiscali.com
Message-ID: <3e3d7ea6_1@mk-nntp-1.news.uk.worldonline.com>
X-Trace: 2 Feb 2003 20:25:10 GMT, ppp-0-47.lond-a-3.access.uk.tiscali.com
Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!newsfeed.icl.net!newsfeed.fjserv.net!colt.net!kibo.news.demon.net!demon!mk-nntp-1.news.uk.worldonline.com!ppp-0-47.lond-a-3.access.uk.tiscali.com
Xref: newsfeed1.easynews.com comp.databases.oracle.server:174520
X-Received-Date: Sun, 02 Feb 2003 13:24:30 MST (news.easynews.com)


"Jonathan Lewis" <jonathan@jlcomp.demon.co.uk> wrote in message
news:b1jqom$r0q$1$8302bc10@news.demon.co.uk...
>
> 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
> >
>
>
>
OP asked if Oracle has a 'snapshot' facililty.
If I wanted to be flippant, I'd suggest the the OP look at 'create
snapshot'.
But if I wanted to actually do the job, I'd do CTAS and select the union all
of the minuses, just as Jonathan suggests.

Regards,
Paul