Re: "Nologging"-option tablespace and tables

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 19 Nov 2003 07:17:13 -0800
Message-ID: <1069255056.622095@yasure>

Volker Hetzer wrote:

> "Jan Korecki" <Jan.Korecki_at_contactor.se> schrieb im Newsbeitrag news:3fbb7b60$0$97839$57c3e1d3_at_news3.bahnhof.se...
>

>>Warning!
>>Be _very_ carful when using nologging and +append in a production database.
>>
>>It is useful sometimes (big batch inserts) but you have to backup the 
>>database afterwards in order to have a consistent backup. Dont play 
>>around with it without coordinating the person responsible for the backups.

>
> Just out of curiosity, is there any reason not to force logging on a production
> database? (alter database force logging)
>
> Greetings!
> Volker

Not one I can think of.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Wed Nov 19 2003 - 09:17:13 CST