Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: {URGENT} SQL Loader Help!!

Re: {URGENT} SQL Loader Help!!

From: Billy Collins <billy_collins_at_my-deja.com>
Date: Thu, 25 Nov 1999 01:36:27 GMT
Message-ID: <81i3qr$o1v$1@nnrp1.deja.com>


Thanks all for the help!! Much appreciated.

Now, I have another problem for which I cannot find documentation help. In my PIPE delimited text file, I have the following text



FER | 19/12/1999
BILLY | 10/12/1999
---

I want to insert the date field into oracle. How do I do it? It gives me
"Maximum length exceeded for the date field"

!!!

Please help!

Thanks a lot in advance for all your timely help!!!

Billy

In article <jv47OFrSYjDcljk6da2cGZzhPNOT_at_4ax.com>,   Fer <ferjaiXXXX_at_latinmail.com> wrote:
>
>
> >What could be the problem here? Actually its a bit perplexing to
> >me..how does one use SQLLDR80 to understand which Database you wish
to
> >connect to? Can I specifically specify it in the command line prompt
> >(MSDOS)?
>
> Try
>
> sqlldr80 userid/Password_at_databasename control=mine.ctl log=mine.log
>
> Fer
>

--

Good day
Billy

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 24 1999 - 19:36:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US