Which is faster:
export and import or
creating a text file and using direct mode in SQL Loader?
Of Course, Import and Export.
2- Much faster
3- You can use the Import and Export Even with fresh Data, but for Loader you may have to create the File again and again.
As Oracledba8 has stated exp/imp would be faster and efficient. One other point I would like to add over to this is using the exp with DIRECT=Y would have a considerable improvement on the imp speed.
Life is a journey, not a destination!
DIRECT=Y in exp will result in speed improvement *for export only*, it will not have any influence on the speed of import whatsoever.
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Click Here to Expand Forum to Full Width