definitely not. if you run out of rollback segment space you should size
your rollback segments appropriately - read larger.
also try using the APPEND hint to insert new rows above the HWM this will be
a lot faster.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Korotky Dmitry" <jedi_at_entecheco.com> wrote in message
news:aa3q1h$u56$1_at_entecheco.com...
> > ok but each day I should udpated the table
> > I must use insert statement
> > Bruno
>
> Maybe the destination table contents indexes, constraints or triggers.
> All of this may decrease the speed of inserting rows.
> In this case, you may drop them before inserting and create them again
after
> one.
>
> And if the number of inserting rows is about 10000 and more then you
should
> insert them by small portions (1000 rows per portion for example). It is
> bacause the rollback segment may overflow...
>
> May the Force be with you!
> Jedi
>
> jedi_at_entecheco.com
>
>
>
Received on Tue Apr 23 2002 - 10:48:06 CDT
