How to disable redo log generation during star transformation

From: Pratap <>
Date: Fri, 26 Aug 2011 04:49:35 -0700 (PDT)
Message-ID: <>


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?

Pratap Received on Fri Aug 26 2011 - 06:49:35 CDT

Original text of this message