Re: ORA-01830 and SQL*Loader

From: Jurij Modic <jmodic_at_src.si>
Date: 1998/11/12
Message-ID: <364b6b33.17212937@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 CST