Re: How to disable redo log generation during star transformation
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Fri, 26 Aug 2011 22:32:46 +0000 (UTC)
Message-ID: <pan.2011.08.26.22.32.45_at_gmail.com>
On Fri, 26 Aug 2011 04:49:35 -0700, Pratap wrote:
Date: Fri, 26 Aug 2011 22:32:46 +0000 (UTC)
Message-ID: <pan.2011.08.26.22.32.45_at_gmail.com>
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.comReceived on Fri Aug 26 2011 - 17:32:46 CDT