Originally posted by esreddy
i have given BUFFER=100000 COMMIT=N
still it is taking so much time
I would set the buffer at around 4,000,000 and commit =Y

This way after 4 million bytes (3MB's roughly) you will commit your insert. With commit=N Oracle will only commit after the entire table is imported, this can be a problem with large tables.

MH