Re: How to disable redo log generation during star transformation

From: Pratap <pratap.deshmukh_at_gmail.com>
Date: Sun, 28 Aug 2011 10:45:49 -0700 (PDT)
Message-ID: <2c6910c7-a69f-4159-8417-102d88b4cf73_at_y21g2000yqy.googlegroups.com>

On Aug 26, 3:42 pm, Mark D Powell <Mark.Powe..._at_hp.com> wrote:
> On Aug 26, 7:49 am, Pratap <pratap.deshm..._at_gmail.com> wrote:
>
>
>
>
>
>
>
>
>
> > Hi,
>
> > The database version is Oracle 11.1
>
> > When star transformation enabled is set to true, I see redo log being
> > generated. I believe this is because of the dimensions being loaded
> > into temp tables (SYS_TEMP_*).
>
> > Is it possible to disable this redo log generation without using
> > temp_disable?
>
> > These temp tables are created in the SYS schema. Can we alter system
> > tablespace to nologging?
>
> > Regards,
> > Pratap
>
> PS - Google won't show me my initial reply but I found the following
> article at Oracle support that tells you how to disable the use of
> temporary tables in a start transformation.
>
> Init.ora Parameter "STAR_TRANSFORMATION_ENABLED" Reference Note [ID
> 47358.1]
>
> HTH -- Mark D Powell --

Thanks -- I would not like to disable the temporary table option. Received on Sun Aug 28 2011 - 12:45:49 CDT