Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question: Is is safe to move a 'plan table' to a temp tablespace???
"BD" <bobby_dread_at_hotmail.com> wrote in message
news:1149265536.856099.119680_at_h76g2000cwa.googlegroups.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/community/oracle_ace/ace1.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.htmlReceived on Fri Jun 02 2006 - 11:43:10 CDT