Re: How to disable redo log generation during star transformation

> Thanks, if the tables were created in the TEMP tablespace, I believe
> they would not have generated redo?

Well, yes and no. While it is true that temporary blocks are not protected by the redo logs, they are protected by the undo structures, to enable normal transaction behavior. Proof is trivial, you can just do following:

create global temporary table t_emp
on commit preserve rows
as select * from emp;
Table created.

Elapsed: 00:00:00.08
SQL> select count(*) from t_emp;

  COUNT(*)

        14

Elapsed: 00:00:00.01
SQL> delete from t_emp;

14 rows deleted.

Elapsed: 00:00:00.01
SQL> rollback;

Rollback complete.

Elapsed: 00:00:00.01
SQL> select count(*) from t_emp;

  COUNT(*)

        14

Elapsed: 00:00:00.00
SQL> So, temporary tables are protected by UNDO blocks and when they are used, redo will still be generated.

-- 
http://mgogala.byethost5.com