Re: SQLLDR Invalid Number on Record 2: Windows to Unix

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 12 Oct 2006 14:02:03 -0700
Message-ID: <1160686922.111481.85900@i42g2000cwa.googlegroups.com>

The ants are driving me crazy wrote:
> Thanks for offering to help. I ended up figuring it out. I'm a
> little embarassed as the problem was much simpler than I assumed. I
> had an incorrect, and not needed, parameter on the INFILE clause.
>
> By the way, what method is most common for loading data into Oracle
> tables? SQLLDR? Stored Procedures? VB/JAVA programs? Something Else?

Typically sqlldr yes but now oracle has support for external tables there are some other very good options.

If you want to read about external tables try a search in http://asktom.oracle.com Received on Thu Oct 12 2006 - 16:02:03 CDT