What is the best and fastest way to copy data from a view to a table
the view and the table are both on same database but different schemas
The no of rows is approx 3 million
currently we are using bulk collect features of 8i
Printable View
What is the best and fastest way to copy data from a view to a table
the view and the table are both on same database but different schemas
The no of rows is approx 3 million
currently we are using bulk collect features of 8i
Insert with Append/Parallel/Nologging is best option.
(BTW, 3 million is not a huge number of records).
Define "Huge"...Quote:
Originally posted by abhaysk
Insert with Append/Parallel/Nologging is best option.
(BTW, 3 million is not a huge number of records).
Anything more than 8 million recs.
8 million is tiny.