Re: How to disable redo log generation during star transformation

From: Pratap <>
Date: Sun, 28 Aug 2011 10:44:57 -0700 (PDT)
Message-ID: <>

On Aug 26, 11:32 pm, Mladen Gogala <> wrote:
> On Fri, 26 Aug 2011 04:49:35 -0700, Pratap wrote:
> > These temp tables are created in the SYS schema. Can we alter system
> > tablespace to nologging?
> Temp tables may be created in SYS schema but are NOT created in the
> SYSTEM tablespace. Temp tables are always created in the TEMP tablespace
> for the issuing schema. If it's the SYS schema, it's the default
> tablespace for the database. Messing with system tablespace is definitely
> not recommended, even if setting it to nologging could actually achieve
> anything.
> --

Thanks, if the tables were created in the TEMP tablespace, I believe they would not have generated redo? Received on Sun Aug 28 2011 - 12:44:57 CDT

Original text of this message