Re: Redo log

No tables or tablespaces will generate archives if your database is in NOARCHIVELOG mode.

;-)

But that's not probably quite what you had in mind...

As I learnt to my cost several months ago, there is no way to entirely switch of the generation of redo for any table, let alone a tablespace. There is a NOLOGGING option (used to be called UNRECOVERABLE in 7, I believe), but this only means that *certain types* of operation (direct loads, create, etc) will not generate redo -normal inserts, updates and deletes will *still* generate redo (and hence, if you are indeed in archivelog mode, archives).

Regards
HJR

--
---------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
---------------------------------------------------------------------------


"Younes Naguib" <ynaguib_at_videotron.ca> wrote in message
news:rJ%P5.2972$Gg5.119263_at_weber.videotron.net...


> Hi,

>

> The answer is probebly No, but it there anyway to have a tablespace or a

> table that does not generate archive log?

>

> Tkx

>

> NY

>

>