Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Huge undotbs during insert

Huge undotbs during insert

From: astalavista <spam_at_nowhere.com>
Date: Wed, 25 May 2005 21:25:36 +0200
Message-ID: <4294d085$0$8043$626a14ce@news.free.fr>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US