Loading one big table into an even bigger table...
From: Simon <stemp1ar_at_yahoo.com>
Date: 16 Jul 2001 21:23:36 -0700
Message-ID: <8fe904ce.0107162023.70bc871b_at_posting.google.com>
Date: 16 Jul 2001 21:23:36 -0700
Message-ID: <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?