I am trying to import about 700,000++ data of excel into the database. When I use the import wizard tool, it will take about 21 hours due to the size of the data. I tried using the alternate table but it won't upload the foreign characters. HELP PLEASE!
Make sure to check the "Use Array DML" box in the import wizard. It will make a big difference in import speed.
I have learned that formulas inside your excel file can also slow the process. There is nothing I can do to make excel go faster in that situation, but if you have formulas, you may be able to export your Excel file to CSV and then import from CSV in Toad.
CLOB columns will slow the process down too, there is also nothing I can do about that.
2 Likes