Thank you
TurkBear <noone_at_nowhere.com> a écrit dans le message :
h1qdtt8t2lpmjqu8v08sc5f20cn1qap3sr_at_4ax.com...
>
> 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:41:43 CDT
