| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: dropping global temp tables
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
-- 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
 |
 |