Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Any possibility for faster INSERTS/UPDATES?
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