You can also use the insert into select * from nologging or unrecoverable depending on the version of oracle.
The nologging or unrecoverable will not generate redo...

regards
anandkl