Re: ORA-01830 and SQL*Loader
Date: 1998/11/12
Message-ID: <364b6b33.17212937_at_news.arnes.si>#1/1
On Thu, 12 Nov 1998 16:17:29 -0600, "Todd Owers" <toddo_at_gcr1.com> wrote:
>Here is the data file. For testing purposes, it has only one line.
>
>B-98765-98 ,11101998 000000,456
>Here is the control file:
>
>LOAD DATA
>INFILE 'test.lst'
>APPEND
>INTO TABLE narrative
> (incident_number POSITION(1:12) CHAR NULLIF incident_number=BLANKS,
> timestamp POSITION(14:28) DATE 'MMDDYYYY HH24MISS' NULLIF
>timestamp=BLANKS,
> payroll_number POSITION(30:32) CHAR NULLIF payroll_number=BLANKS
>)
>
>Can anyone shed some light on this? Thanks in advance for your help.
What are your database/SQL*Loader versions? I tried it with the table creation script, controlfile and the sample data you provided on my PO 7.3.2 and it worked fine.
>Todd Owers
>toddo_at_gcr1.com
HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)
The above opinions are mine and do not represent any official standpoints of my employer Received on Thu Nov 12 1998 - 00:00:00 CET