If you get "ORA-14452 (See ORA-14452.ora-code.com): 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@(protected) >
To: <oracle-l@(protected) >
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@(protected)
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
