Re: dropping global temp tables

On 07/29/2004 03:43:08 PM, Jonathan Gennick wrote:
> 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.

$ sqlplus scott/tiger  

SQL*Plus: Release 10.1.0.2.0 - Production on Thu Jul 29 17:15:09 2004  

Copyright (c) 1982, 2004, Oracle. All rights reserved.    

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production With the Partitioning, OLAP and Data Mining options  

SQL> create global temporary table jonathan (a number)   2 on commit preserve rows;  

Table created.  

SQL> drop table jonathan;  

Table dropped.  

SQL> Interesing thing is that global temporary tables are NOT preserved in the recycle bin.

-- 
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
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
-----------------------------------------------------------------