Re: How to disable redo log generation during star transformation

From: Pratap <pratap.deshmukh_at_gmail.com>
Date: Sun, 28 Aug 2011 10:44:57 -0700 (PDT)
Message-ID: <d10f9262-97b7-447e-a317-5e732539f2bb_at_w28g2000yqw.googlegroups.com>



On Aug 26, 11:32 pm, Mladen Gogala <gogala.mla..._at_gmail.com> 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.
>
> --http://mgogala.byethost5.com

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