Re: Oracle table snapshot

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 2 Feb 2003 19:15:33 -0000
Message-ID: <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

>

Received on Sun Feb 02 2003 - 13:15:33 CST