Re: Creating Temporary Tables in Oracle.

From: Vsevolod Afanasjev <afanasjev_at_cse.unsw.edu.au>
Date: 1997/10/06
Message-ID: <34384F2F.2101@cse.unsw.edu.au>#1/1

What exactly do you mean as "temporary table"? table which exists only for duration of particular session so you don't need to issue DROP TABLE before disconnecting?
Or table which is automatically dropped during startup or shutdown?

The temporary objects available are:
1. particular tablespace designated as temporary for particular user.
2. the whole tablespace designated as temporary (since 7.3).

However, if your temporary tables are small enough ti fit in memory, you can build them (in Oracle8) using such features as VARRAY. Seva

Brian Grosheim wrote:
>
> Can temporary tables be created in Oracle 7? Oracle8? If so what is
> the syntax for creating them and is there limitiations?
>
> -- Brian Grosheim
Received on Mon Oct 06 1997 - 00:00:00 CDT