ndisang: I could create a new db and start again, but we are talking of more than 100 db's arount one whole country for a total of about 50.000.000 rows and more! It would be WAY too long!!

PAVB: Oracle said we should move to at least 9i, but the problem is that we have a lot of programs and applications that are linked to these db's so we are trying to update to 8.1.6 first so that we don't have to create new applications, and then test new possibilities.

Thx!