Re: Sessions using TEMP and sharing extents

On Jul 10, 12:57 pm, DA Morgan <damor..._at_psoug.org> wrote:
> fitzjarr..._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
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
>
> - Show quoted text -

No, I wouldn't, if you really want to be picky:

ORA-02195: Attempt to create PERMANENT object in a TEMPORARY tablespace

I believe says much.

David Fitzjarrell Received on Tue Jul 10 2007 - 13:30:49 CDT