Re: Question re temporary tablespace

Hi,

I don't believe that you are able to say that you want actions, or every action that takes place on a specific tablespace to be not logged. (unless stating nologging on the action (DDL) itself ) ex:
create index xpto .... tablespace IDX
-- This is always be logged even if the tblspc IDX created with nologging create index xpto .... tablespace no_matter_what unrecoverable|nologging -- This creation will not be logged

Therefore the set NOLOGGING should be considered, IMVHO (V states for very), for TBLSPC creation time only.

If you have to recover any DB after creating a TBLSPC with NOLOG... you will have to create that TBLSPC by hand before you can apply anything (ex:arch logs) that concerns with that TBLSPC.

That for me, make sense.

J. Meirim

"Nuno Souto" <nsouto_at_nsw.bigpond.net.au.nospam> wrote in message news:3b14e5a9.10203170_at_news-server...
> V8.0.x and V8.1.x:
>
> Is there any advantage/problem/whatever in setting a tablespace
> defined as TEMPORARY, also as NOLOGGING?
>
> I can't for the life of me see why NOLOGGING or LOGGING would be
> relevant for a TEMPORARY tablespace, but someone at work asked and I
> couldn't find anything saying yay or nay in the doco. And if I try to
> set a TEMPORARY tablespace as NOLOGGING, it lets me.
>
> TIA for any insights.
>
> Cheers
> Nuno Souto
> nsouto_at_bigpond.net.au.nospam
> http://www.users.bigpond.net.au/the_Den/index.html
Received on Wed May 30 2001 - 12:03:47 CDT