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