From oracle-l-bounce@freelists.org Wed May 5 16:20:36 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i45LKLY13132 for ; Wed, 5 May 2004 16:20:31 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i45LKB613087 for ; Wed, 5 May 2004 16:20:21 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DB77A72D602; Wed, 5 May 2004 16:09:14 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14897-60; Wed, 5 May 2004 16:09:14 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 02A0872E164; Wed, 5 May 2004 16:09:14 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 05 May 2004 16:07:55 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 942BC72DCA0 for ; Wed, 5 May 2004 16:07:34 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14804-36 for ; Wed, 5 May 2004 16:07:34 -0500 (EST) Received: from mail.acelerate.com (mail.acelerate.com [200.105.128.132]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id B532F72E19E for ; Wed, 5 May 2004 16:07:30 -0500 (EST) Received: (qmail 1682 invoked from network); 5 May 2004 21:21:21 -0000 Received: from dazasoftware.com (HELO org48l7d9ara8b) (200.105.151.94) by 0 with SMTP; 5 May 2004 21:21:21 -0000 Message-ID: <021c01c432e6$648e97f0$2501a8c0@dazasoftware.com> From: "Juan Cachito Reyes Pacheco" To: References: <409957B3.30554C03@sun.com> Subject: Re: PLAN_TABLE gotcha in 10g Date: Wed, 5 May 2004 17:17:36 -0400 MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4523 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jreyes@dazasoftware.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org What could happen if you drop that table and recreate as a no global temporary table? Basically I don't think this could cause nothing unless something from the automatic tunning 10g feature use it. I don't you lose nothing trying this if you are in a test database. :) Juan Carlos Reyes Pacheco OCP Database 9.2 Standard Edition ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------