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

Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: dropping global temp tables

Re[2]: dropping global temp tables

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Thu, 29 Jul 2004 17:38:46 -0400
Message-ID: <1511478314.20040729173846@gennick.com>


Ok. I think I see the problem. I was trying to drop the plan_table that Oracle Database 10g creates automagically as a global temp table in the event you do not manually create a plan_table. I wanted to test something regarding that, though at the moment I've forgotten whatever it was that I wanted to test that led me to this point.

There's a trailing $ on table name, so, even though it's DESCRIBE plan_table, it's DROP plan_table$;

Best regards,

Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com

Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://five.pairlist.net/mailman/listinfo/oracle-article, or send email to Oracle-article-request_at_gennick.com and include the word "subscribe" in either the subject or body.

Thursday, July 29, 2004, 4:15:02 PM, Tanel Põder (tanel.poder.003_at_mail.ee) wrote: TP> Hi!

TP> Which error message do you get?

TP> If you get "ORA-14452: attempt to create, alter or drop an index on
TP> temporary table already in use" then make sure that no sessions have active
TP> transactions involving the GTT or don't have any rows in the table in case
TP> of "on commit preserve rows" GTT.

TP> Tanel.

TP> ----- Original Message ----- 
TP> From: "Jonathan Gennick" <jonathan_at_gennick.com>
TP> To: <oracle-l_at_freelists.org>
TP> Sent: Thursday, July 29, 2004 10:43 PM
TP> Subject: dropping global temp tables


>> Sorry if this is the dumb question for the day, but how does
>> one go about dropping the definition for a global temp
>> table? DROP TABLE doesn't do the job for me.
>>
>> Best regards,
>>
>> Jonathan Gennick --- Brighten the corner where you are
>> http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com

TP> ----------------------------------------------------------------
TP> Please see the official ORACLE-L FAQ: http://www.orafaq.com
TP> ----------------------------------------------------------------
TP> To unsubscribe send email to:  oracle-l-request_at_freelists.org
TP> put 'unsubscribe' in the subject line.
TP> --
TP> Archives are at http://www.freelists.org/archives/oracle-l/
TP> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
TP> -----------------------------------------------------------------

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_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
-----------------------------------------------------------------
Received on Thu Jul 29 2004 - 16:35:44 CDT

Original text of this message

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