Re: Unlogged Deletes in Oracle

From: Mark Bole <makbo_at_pacbell.net>
Date: Tue, 30 Nov 2004 16:44:46 GMT
Message-ID: <2s1rd.52036$QJ3.31876@newssvr21.news.prodigy.com>

Scott Swank wrote:

> "Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<41ac4dee$0$8929$afc38c87_at_news.optusnet.com.au>...
>

>>Peter Nolan wrote:
>>
>>>Hi All,
>>>I am coming to grips with what 'nologging' means in Oracle. 
>>

[...]

>>
>>Don't forget that best practice after any nologging operation that 
>>actually does indeed generate no redo is to perform a new backup. (IE, 
>>you never actually win with Oracle: the time and effort you save on the 
>>DML side of things is usually expended on the index creation/extra 
>>backup side of things).

>
>
> Another suprisingly efficient option is to
>
> CREATE TABLE new_table NOLOGGING AS
> SELECT *
> FROM old_table
> WHERE good_data;
>

[...]

Beware the existence of a Data Guard standby database and FORCE LOGGING as well, if it applies in your situation.

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10739/tspaces.htm#sthref1160

-Mark Bole Received on Tue Nov 30 2004 - 10:44:46 CST