Re: Huge undotbs during insert

astalavista wrote:
> 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

Before we get to the question you asked ... the current 9i version is 9.2.0.6 ... apply the appropriate patches.

Second ... how big is the table and how big is your UNDO tablespace?

I prefer going after the low hanging fruit before heading for the esoterica.

-- 
Daniel A. Morgan
Relational theory is not something that is simply a nice-to-have.
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)