"BD" <bobby_dread@hotmail.com> wrote in message
news:1149265536.856099.119680@h76g2000cwa.googlegr oups.com...
>> In 10g, the default install of the plan_table
>> table is a global temporary table
>
> Sorry forgot to say I'm running 8.1.7.4 here. Bit of a different world.
>
>

On the other hand, if you look closely
you will note that I've put:

I've [done] the same sort of thing in 8i and 9i
but using the system schema for the last
few years.

--
Regards

Jonathan Lewis
http://www.oracle.com/technology/com...ce1.html#lewis

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html