Question on Loading one big table into an even bigger table...

I am very new to 8i and I would like to enhance a stored proc using some of the features in Oracle 8i.

Currently I have a cursor that selects all records from one table and inserts them into another table since the two tables reside within the same schema and are identical(one is a table containing 1 month of data while the other contains all months of data). I dont believe I can use export import because primary key is being created using a trigger with a sequence generator.

I have looked at the bulk collect and the problem is the smaller table has @ 900,000 records and is growing.

What ways would you suggest to speed up the process using oracle 8i features? Received on Mon Jul 16 2001 - 16:07:15 CDT