Well, I bet Wolfgang meant to use GTT appropriately. :) I.e. insert
into them and not recreate them every time.
On 11/27/06, Grant Allen <gxallen_at_gmail.com> wrote:
> On 11/28/06, Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
> > How about using GTTs rather than creating tables on the fly. Changing
> > attributes of dictionary tables, if that's what you mean by
> > increasing freelist, is a sure way for your database to become unsupported.
>
> GTTs still touch sys.obj$ (at least, in the 9i test I just did)
--
Best regards,
Alex Gorbachev
The Pythian Group
Sr. Oracle DBA
http://www.pythian.com/blogs/author/alex/
http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 27 2006 - 21:10:14 CST
