Re: Sessions using TEMP and sharing extents

On Jul 10, 10:17 am, DA Morgan <damor..._at_psoug.org> wrote:
> fitzjarr..._at_cox.net wrote:
> > Also no permanent
> > objects can occupy space in a true tempoary tablespace.
>
> Being picky here ... but with the exception of a global temporary table.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Too picky, as Oracle does not consider a global temporary table to be a permanent object:

"Unlike permanent tables, temporary tables and their indexes do not automatically allocate a segment when they are created. Instead, segments are allocated when the first INSERT (or CREATE TABLE AS SELECT) is performed. This means that if a SELECT, UPDATE, or DELETE is performed before the first INSERT, the table appears to be empty."

Note, please, the first three words in that quote.

I stand by my original statement.

David Fitzjarrell Received on Tue Jul 10 2007 - 12:38:37 CDT