Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Question: Is is safe to move a 'plan table' to a temp tablespace???

Re: Question: Is is safe to move a 'plan table' to a temp tablespace???

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 2 Jun 2006 17:43:10 +0100
Message-ID: <ZNSdne97aN0K9x3ZnZ2dnUVZ8tydnZ2d@bt.com>


"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.html
Received on Fri Jun 02 2006 - 11:43:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US