Pb Table comparison

other
1

I’ve got an error oracle : ORA01555 snapshot too old : rollback segment too small… My dba says that the place for the rollback is already very big…

I want to update more than 600,000 records in my table. Is there an another way to do without the Table Comparaison ?

Thanks for your response (excuse me for my poor english…)

Philippe

pvandenberch (BOB member since 2004-05-10)

2

When you update the records break them into smaller pieces (10k records at a time for example) and commit in between.

As an alternative you could possibly use bulk load - please, ask your DBA for details.

Andreas :de: (BOB member since 2002-06-20)