Re: Question re temporary tablespace

From: Howard J. Rogers <howardjr_at_www.com>
Date: Wed, 30 May 2001 22:58:41 +1000
Message-ID: <3b14ee9d@news.iprimus.com.au>

I've often wondered about that too, I have to say, since I don't think any swapped sort information genuinely gets to the log files anyway (though I'd imagine that the first swap that causes the creation of the temporary segment causes the relevant entries on the data dictionary tables to be logged, whereas 'nologging' would stop that). Hardly a show stopper, I agree.

The issue is moot, of course, with the 8.1.x 'create temporary tablespace blah tempfile 'x/x/x.dbf'" syntax, since that's automatically a nologging construct.

Regards
HJR

--
=============================!!=============================
The views expressed are my own only, and definitely NOT those of Oracle
Corporation
=============================!!=============================


"Nuno Souto" <nsouto_at_nsw.bigpond.net.au.nospam> wrote in message
news:3b14e5a9.10203170_at_news-server...


> V8.0.x and V8.1.x:

>

> Is there any advantage/problem/whatever in setting a tablespace

> defined as TEMPORARY, also as NOLOGGING?

>

> I can't for the life of me see why NOLOGGING or LOGGING would be

> relevant for a TEMPORARY tablespace, but someone at work asked and I

> couldn't find anything saying yay or nay in the doco.  And if I try to

> set a TEMPORARY tablespace as NOLOGGING, it lets me.

>

> TIA for any insights.

>

> Cheers

> Nuno Souto

> nsouto_at_bigpond.net.au.nospam

> http://www.users.bigpond.net.au/the_Den/index.html

Received on Wed May 30 2001 - 07:58:41 CDT