If you don't have to manipulate any of the data then SQL*Loader is the way to go. If you have to do any sort of manipulation of the data then it is very difficult to use SQL*Loader. Personally I user perl to load my data because I have to format some of the data and replace some of the values. It is definitely slower than SQL*Loader, but it gets the job done. Plus SQL*Loader can be a pain to use. As far as your question about Direct Pass I don't think DBD can do that. Hope that helps.
Thanks, Sam Gold -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, February 26, 2004 5:57 AM To: [EMAIL PROTECTED] Subject: Oracle Direct Pass Hello, Sorry if it is FAQ. So called "Direct Pass" can be used by DBD::Oracle? I ususally load data by my script made with DBI/DBD::Oracle. But sometimes when the data is so big I wonder if I shoud use my script or use SQL*LOADER. I like Perl so much but I can't wait so long. I like to know perl script is how fast than SQL*LOADER. Any hint on speeding up perl script when loading mass data? Regards, Hirosi Taguti [EMAIL PROTECTED]
