-
sqlloader
I want to load a ascii flat file which will contain at least 1 million rows on a daily basis to oracle 10g database . I am planning to use sqlloader utility. Can someone please advise if it is a good tool to use for 1 million rows on a daily basis from performance perspective. Data from flat consists of 15 columns of character data less than 200 characters each field. I cannot use any third party tools.
-
that will only take a few minutes at most with sqlloader if you use direct=true
-
Thanks for your reply. Are they any other fastest utilities with 10g?
-
external tables will be of comparable performance