Re: dropping global temp tables

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Thu, 29 Jul 2004 23:15:02 +0300
Message-ID: <019d01c475a8$bb9b9e30$36ae9fd9@porgand>

Hi!

Which error message do you get?

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

Tanel.

• Original Message ----- From: "Jonathan Gennick" <jonathan_at_gennick.com> To: <oracle-l_at_freelists.org> Sent: Thursday, July 29, 2004 10:43 PM 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

---

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 - 15:19:07 CDT