Re: Sessions using TEMP and sharing extents

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 10 Jul 2007 10:57:42 -0700
Message-ID: <1184090260.543333@bubbleator.drizzle.com>

fitzjarrell_at_cox.net wrote:
> 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

Good lord man you're pickier than I am.

But would you agree that while the segment is not permanent the object is?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Tue Jul 10 2007 - 12:57:42 CDT