Re: Loading one big table into an even bigger table...

insert into tableBig as select .... from tableSmall where... commit;
That's the fastest way to do it. Much faster than plsql cycling through the records and inserting them even in an array fashion (bulk collect.) Jim
"Simon" <stemp1ar_at_yahoo.com> wrote in message news:8fe904ce.0107162023.70bc871b_at_posting.google.com...
> 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 _at_ 900,000 records and is growing.
>
> What ways would you suggest to speed up the process using oracle 8i
> features?
Received on Tue Jul 17 2001 - 07:03:57 CEST