Re: "Nologging"-option tablespace and tables

"Jens Mueller" <jens_at_jensel.com> schrieb im Newsbeitrag news:gs1nrvkkdh1gsnmsc4hlj4c9gm1rkacg29_at_4ax.com...
> He Jan,
>
> thanks for the answer.
>
> The reason why I asked is, that we have an application, where not
> every data must be written to the redo.
Since you are german and "must" is slightly different there, do you really mean "it is forbidden/harmful to write this data to the logfile" or just "it isn't necessary for the functioning of the application"?

> This are some session-handling
> tables, temp-tables etc. These table dont cover an important data.
> So the question for us is:
> Do we have to create an extra-tablespace with nologging-option (and
> move the tables into that new tablespace) or is enough to disable this
> option at the table itself?

Temp/undo stuff doesn't get logged anyway. And any other unlogged stuff kills your recovery. At least, if you want to recover beyond the last backup (i.e. by applying archivelogs). Ditto for standby databases.

Lots of Greetings!
Volker Received on Wed Nov 19 2003 - 10:20:54 CST