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

[Simon]

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?