Re: SQL Loader question

Mark Istvan <mistvan_at_ix.netcom.com> wrote:

>Has anyone successfully used SQL Loader from Oracle?
>What might be some problems that would prevent an input delimited ASCII
>file from being loaded?
 

>Any other comments, suggestions, thoughts is greatly appreciated!!
 

>Mark Istvan
>mistvan_at_ix.netcom.com

We've used it successfully. Most of the problems we've encounter are data errors. The data we're building the ascii files from is coming from a database without strong column typing and there's no guarantee that a "numeric" field won't contain alpha data for example. Same thing with dates. If you get enough of these errors and don't set the ERRORS option sufficiently high the load will eventually abort.

If you're loading large volumes of data, make sure the storage parameters of the tables can handle the volume or else you'll end up exceeding the max # of extents (not to mention having very fragmented tables).

--
Chuck Hamilton
chuckh_at_ix.netcom.com

Incoming fire has the right of way!