Re: Temporary Table Howto

From: Craig M. Wall <cwall_at_petersons.com>
Date: Thu, 21 May 1998 10:17:51 -0400
Message-ID: <6k1d2v$g5g@news9.noc.netcom.net>

George,

Do not create any object, much less a table, in the temporary tablespace. That tablespace should be reserved for SYS activities involving temporary segments.

There is no direct analog of an Informix temporary table in Oracle. You may want to investigate the use of PL/SQL tables.

Craig M. Wall

George wrote in message <3563569F.9AE05C5E_at_home.com>...
>I've used Informix temp tables which are identified using a specific
>naming convention and are accessible only to the creating
>session for the lifetime of the session and when you logout the table
>disappears.
>
>If I create an ORACLE table in a temporary tablespace does it behave
>the same way. ORACLE's documentation on temporary tables is not clear.
>I'd appreciate a pointer or an email example.
>
>TIA
>George
Received on Thu May 21 1998 - 09:17:51 CDT