Re: Trouble with SQLLDR

Oracle releases are NEVER 'forward compatible', meaning that your 7.3.x database cannot usually use utilities from later releases. You were lucky with SQLLDR80, as it apparently could use the 7.3 dictionary and views (or the 8.0 dictionary/views did not change from what 7.3 was using with respect to SQL*Loader). SQLLDR81 CANNOT use the 7.3 dictionary and views, and this is made glaringly apparent by the error messages you have seen when attempting to use this with a 7.3.x database.

Accept the fact that utilities for later releases are not suitable for use with earlier versions of Oracle.  

"Sofresud" <contact_at_sofresud.com> wrote in message news:<9r647n$p4h$1_at_wanadoo.fr>...
> Hi,
>
> I get some trouble with sqlldr that i got difficulties to understand. Here
> is my problem :
>
> my data file is :
> "1";"2"
> "3";"4"
> "5";"6"
>
> my table DUDE is (result of desc DUDE ) :
> COL1 NUMBER(3)
> COL2 NUMBER(3)
>
> my controlfile is :
> LOAD DATA
> INFILE 'd:/tmp/dude.dat'
> INTO TABLE DUDE
> FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"'
> (COL1, COL2)
>
> My ORACLE DB version is 7.3
> when i use SQLLDR73, it works fine ( 3 rows loaded )
> when i use SQLLDR80, it works fine ( 3 rows loaded )
> when i use SQLLDR81 ( from client version 8.1.6), it doesn't work fine at
> all.
> The given reason is :
> 1st row : row rejected - ORA-00926 keyword VALUES ....
> 2nd row : row rejected - ORA-01003 ...
> 3rd row : row rejected - ORA-01003 ...
>
> The question is simple : why ? thanks for you help
Received on Wed Oct 24 2001 - 14:47:15 CDT