Re: Snapshot Too Old

without addressing the snapshot too old problem, could you use either of export/import or the SQL*Plus copy command? these are probably much faster than the approach you identify below.

steve long
"The world's best technology strategist." (TM)

<u518615722_at_spawnkill.ip-mobilphone.net> wrote in message news:l.987089246.1892639160@[198.138.198.252]...
> I have to move 100m rows to another table
> use select/insert in PL/SQL. We have 10 rollback
> segments and a huge RBS tablespace, plenty
> room for rollback segment to grow.
>
> At first, we try to commit every 200 rows, and
> we always got the error message snapshot too
> old after about 200,000 rows, we begin to reduce
> the times of commit,commit every 2000, 20,000 and
> 200,000 and now 2,000,000 rows. It is still running
> and it takes a long time to know whether it will work
> or not.
>
> Could somebody tell me why commit too often will
> also cause the error snapshot too old?
>
> How do you decide how many rows to commit?
>
> Thank you very much for your help.
>
>
>
>
>
>
>
>
> --
> Sent by dbadba62 from hotmail subpart of com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Thu Apr 12 2001 - 15:44:22 CDT