ive found through repeated use that its faster to direct path load the data to a
staging table then do an insert /*+ append */ to move the data over to the master
table.
speed of inserts will depend on how many indexes you have.
however, since you are on 9i you dont need to use either. use an
Try external tables or checkout a good article written by Stephen Andert from this
list which was a review for Jonathan Gennick's sqlloader book
The link is http://www.oreillynet.com/pub/a/oreilly/oracle/news/oraclesqlload_0401.html
Key factors are bindsize and rows settings
John
