Re: Tables and NOLOGGING

From: John Chiu <johnymc_at_netscape.net>
Date: Tue, 14 Dec 1999 23:45:53 -0500
Message-ID: <83767l$n7q$1@news2.tor.accglobal.net>

nologging means the transaction not recorded in redo log. It is not recoverable to the point in time of failure because the transaction is not recorded in the redo log and the archived log files. It can be partially recovered upto the last full database backup.

John Chiu

David F. Newman <buzzwang_at_churchill.ourvillage.com> wrote in message news:86bt7tje2o.fsf_at_churchill.ourvillage.com...
> Hi there,
> I was reading the manual and I found it a little
> vague regarding one point. When you set a table to
> NOLOGGING does that only make the table unrecoverable
> after direct loads with SQL*Loader or is it unrecoverable
> after any DML? Anyone know? Thanks.
>
> --
> David F. Newman
> Oracle DBA/Unix admin
> dnewman_at_ourvillage.com
Received on Tue Dec 14 1999 - 22:45:53 CST