Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Huge undotbs during insert
Hi,
I have to duplicate a big table
so I did:
insert /*+ append nologging */
into table2
select * from table1;
The operation failed due to
the filling of the UNDOTBS
Is it normal to have up to 4 times ( or more ) the size
of table1 in undotbs ?
How can I speed up this operation ?
I tried parallel :
alter session enable parallel dml;
insert /*+ append nologging parallel (table1,4) */
into table2
select * from table1;
but no parallel processing occurred ...
Thanks for your help ...
Oracle 9.2.0.1
HP-UX 11.0
Received on Wed May 25 2005 - 14:25:36 CDT