RE: dropping global temp tables

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Thu, 29 Jul 2004 16:15:37 -0400
Message-ID: <564DE4477544D411AD2C00508BDF0B6A2133DE3A@usahm018.exmi01.exch.eds.com>

Try again. Using 9.2.0.4 running on AIX 5.2 I created and dropped a temporary table using just
DROP TABLE table_name

HTH -- Mark D Powell --

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jonathan Gennick Sent: Thursday, July 29, 2004 3:43 PM
To: oracle-l_at_freelists.org
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:21:33 CDT