Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |