Re: Trouble with SQLLDR

The 8.1 stuff is not backward compatible with earlier versions of the database in many cases..To load data into a 7.3 database I would not use 8.1 version tools..There can be problems that might not even show as an error but would result in incorrect or invalid data ....stay with the tools that brung ya' - its a 7.3 database so use v7 tools.. ( actually I expect Sybrand to reply that you need to upgrade the database - altogether a good idea)

"Sofresud" <contact_at_sofresud.com> wrote:

>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
>
>
>
>
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Wed Oct 24 2001 - 11:16:54 CDT