Re: "Nologging"-option tablespace and tables

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Wed, 19 Nov 2003 15:35:24 +0100
Message-ID: <bpfv3e$95s$1@news.fujitsu-siemens.com>

"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 Received on Wed Nov 19 2003 - 08:35:24 CST