RE: dropping global temp tables

  • From: "Powell, Mark D" <mark.powell@xxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 29 Jul 2004 16:15:37 -0400

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Jonathan Gennick
Sent: Thursday, July 29, 2004 3:43 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxx


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: