Re: How Do I Create a Temporay Table?

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/03/09
Message-ID: <5fthkv$lnr@mtinsc04.worldnet.att.net>#1/1

You can create a temporary table starting with Version 7.3, although in a roundabout way: 1) create a temporary tablespace using the PERMANENT/TEMPORARY clause of the CREATE TABLESPACE statement (PERMANENT is the default value for the clause); 2) create the table you want to be a temporary table in that tablespace. I believe you still need to grant the owner of the table quota privileges in that tablespace, as with any tablespace, if (s)he is to be allowed to create objects in that tablespace.

Although ORACLE Corp. claims that ORACLE is SQL-92 compliant, the SQL-92 standard allows for the direct creation of a temporary table using CREATE TEMPORARY TABLE ... statement.

Michael Serbanescu
Senior Consultant, MIACO Corporation

---

"CSI" <mail34067_at_pop.net> wrote:
>Oracle doesnt seem to be having equivalent of temp tables/ tempdb as in SQL
>Server.
>A "temporary" tablespace is used by oracle automatically for sorting
>operations ( provided it is assigned as temporary tablespace for the user
>). Even the segments allocated here are NOT dropped after the query; it is
>available for other users. (SQL Server drops all local temporary tables
>after the session ).
>//ram
>
>
Received on Sun Mar 09 1997 - 00:00:00 CST