Question re temporary tablespace

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Wed, 30 May 2001 12:30:28 GMT
Message-ID: <3b14e5a9.10203170@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:30:28 CDT