RE: Simplest way to create/use PLSQL collections

Bug 2874489 Excessive REDO generated for INSERT as SELECT into GLOBAL TEMPORARY TABLES Using 'insert as select' to insert into a global=20 temporary table can generate far more redo than=20 the same insert into a permanent table.

Updates and deletes are not affected, only multirow inserts.

Affects:
Product (Component) Oracle Server (Rdbms)=20 Range of versions believed to be affected Versions < 10.1.0.2 =20 Versions confirmed as being affected 9.2.0.4=20
=20

Platforms affected Generic (all / most platforms affected)=20

Fixed:
This issue is fixed in 9.2.0.5 (Server Patch Set)=20 10.1.0.2=20
=20

--
http://www.freelists.org/webpage/oracle-l