Re: tablespace problem

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 23 Apr 2005 07:06:44 +0200
Message-ID: <kslj61t4m0c762qa9drcblkreuh438fg73@4ax.com>

On Sat, 23 Apr 2005 12:51:16 +0800, Brian Leung <c50342182003_at_yahoo.com.hk> wrote:

>Hi all,
>I am new in oracle.
>If I create a tablespace in nologging mode, the redo log of this
>tablespace will not generate. Right?
>Thank you

No. Incorrect
Nologging only applies to direct loads and inserts in append mode. And turning logging complete off (which is possible with undocumented parameters) will render your database corrupt.

--
Sybrand Bakker, Senior Oracle DBA

Received on Sat Apr 23 2005 - 00:06:44 CDT