Tuning database for inserts

We have an Oracle 7.3. database on an NT4Server.

To build the database we are inserting data into tables from ascii files, and from imports from other Oracle databases.

What would you recommend the best set up of the Database to be - the imports are approx 1.7 million rows max?

• should we have a lot of small sized Rollback segments, (how many?,What size?)

what other initialisation parameters would you recommend setting, that would improve performance speed when inserting the data.

Thanks in advance

Ian Received on Fri Jan 23 1998 - 00:00:00 CST