temp table

From: Denis Langlais <langlais_at_ibm.net>
Date: Mon, 13 Apr 1998 22:01:39 -0300
Message-ID: <3532B573.6632@ibm.net>

Does anyone know how to create temporary tables in Oracle which will be dropped automatically.

create table abc as
select * from table xyz
tablespace TEMP_TB;

Also, If many people are running the same script they won't bomb out because the table already exists? --

---

You can email me: Denis Langlais using the following address langlais_at_ibm.net Received on Mon Apr 13 1998 - 20:01:39 CDT