fitzjarrell_at_cox.net wrote:
> 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
You win. I will stand down.
--
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 - 17:17:23 CDT
