How to disable redo log generation during star transformation
From: Pratap <pratap.deshmukh_at_gmail.com>
Date: Fri, 26 Aug 2011 04:49:35 -0700 (PDT)
Message-ID: <f8d04b67-a939-4716-8399-9d0ffd01468c_at_p10g2000yqi.googlegroups.com>
Hi,
Date: Fri, 26 Aug 2011 04:49:35 -0700 (PDT)
Message-ID: <f8d04b67-a939-4716-8399-9d0ffd01468c_at_p10g2000yqi.googlegroups.com>
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
Received on Fri Aug 26 2011 - 06:49:35 CDT