Re: NOLOGGING Option on Create Table

On 6 Apr 2002 11:17:49 -0800, Thomas Kyte <tkyte_at_oracle.com> wrote:

>I see people say things like "and *I* will never need to recover them". That is
>wrong. You will need to recover that many times in your lifecycle.
>

Hi Tom,

I would be interested in your opinion concerning data warehousing / DSS / Analytic Databases which are used for querying only and say completely rebuild each night. I that case I tend to avoid archiving, logging etc. If the database crashes, well, users will be unhappy for not being able to work on it today, but 'til tomorrow it's fixed and NO data is lost.

regards
Marc Blum
mailto:marc_at_marcblum.de
http://www.marcblum.de Received on Sun Apr 07 2002 - 08:18:57 CDT