Any possibility for faster INSERTS/UPDATES?

From: Randi Wølner <rw_at_computas.no>
Date: Wed, 18 Oct 2000 08:02:57 GMT
Message-ID: <ROcH5.1093$G3.179425280@news.telia.no>

I am working with conversion of a large quantity of data that are first read from text files into Oracle tables, and then processed and put into different tables. I was very satisfied with using the 'Direct Path' option of SQL*Loader, so reading the data into Oracle goes real fast.

But - after loading the data I do lots of inserts and updates to put the data into many tables, and this takes lots of time. When this job will be done 'for real' I will have the database on my own. Is there any option in Oracle I could use to 'disable' the use of rollback segments, to make things speed up?

Thanks,
Randi Wølner Received on Wed Oct 18 2000 - 03:02:57 CDT