The best solution is to use the SQL Loader utility with in Direct mode. This mode bypasses most of the Oracle database processing. It reads the datafile, converts the data into datablocks and writes them to disk. It saves lot of time and good for bulk data loading.




Reply With Quote