Re: Question re temporary tablespace

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 31 May 2001 08:27:08 +0200
Message-ID: <2nobhts30p8il0oi3p0jt77siuqr2t3u96@4ax.com>

On Wed, 30 May 2001 22:58:41 +1000, "Howard J. Rogers" <howardjr_at_www.com> wrote:

>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
I was told by an Oracle consultant *many* years ago (we were running Oracle 6 at that time, remember that beast?) temporary segments by design are not logged.

Regards

Sybrand Bakker, Oracle DBA Received on Thu May 31 2001 - 01:27:08 CDT