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@(protected)
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@(protected) 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@(protected)) wrote:
TP > Hi!
TP > Which error message do you get?
TP > If you get "ORA-14452 (See ORA-14452.ora-code.com): 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@(protected) >
TP > To: <oracle-l@(protected) >
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@(protected)
TP > -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
TP > Please see the official ORACLE-L FAQ: http://www.orafaq.com
TP > -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
TP > To unsubscribe send email to: oracle-l-request@(protected)
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
