C Chang wrote:
> C Chang wrote:
>
>>Sybrand Bakker wrote:
>>
>>>On Fri, 25 Apr 2003 23:41:22 -0400, C Chang <cschang_at_maxinter.net>
>>>wrote:
>>>
>>>
>>>>My DB server is 8.1.6.1 on a NT 4 and my client is installed with
>>>>8.1.6.0 client ( on NT 4 workstation). I created a table (A) and a view
>>>>of the table (A-view). when I tried to use the sqlldr to import a .csv
>>>>file to APPEND INTO TABLE schema.A-view (...) by an import.ctl, I got an
>>>>error message saying that the schema.A-view does not exist. Since I
>>>>used another machine (NT4 ) equiped with 8.1.5 for the same task and
>>>>worked, so there is something wrong with either the sqlldr utility or
>>>>the client 8.1.6.0. On my 8.1.5 client machine, the sqlldr utiltiy is
>>>>sqlldr80, but on 8.1.6 is sqlldr. Any different?
>>>>
>>>>C CHang
>>>
>>>All obsolete software. On the other machine though you are using an
>>>incorrect version of sqlldr, namely the sqlldr of 8.0 against an 8.1
>>>database. So I would guess you would better check the error message of
>>>sqlldr in sqlplus and upgrade your software anyway, before you run
>>>into real trouble: 8.1.6 is a bug ridden release, and you should have
>>>upgraded a long time ago. You still have 7 monts before 8i is
>>>history!!
>>>
>>>Sybrand Bakker, Senior Oracle DBA
>>>
>>>To reply remove -verwijderdit from my e-mail address
>>
>>Does that I mean if I upgrade my DB server to 8.1.7 or 9i, I have to ask
>>all my clients (1750 total) to install 8.1.7 or 9i client on their
>>stations? I thought in term of the sqlldr utility, higher version on
>>server will accept anything from the lower vesion of cleint.
>>
>>C Chang
>
> Sorry to make ahorrible statement of the number client I have. It is 175
> total at 6 different sites (states).
>
> C Chang
Might very well be - sqlldr has changed, too, and Sybrand is usually
very well informed about peculiarities of the releases.
I, for one, ran against the incompatibility of exp (8.1.6) vs.
exp (8.1.7) - the views being used are altered, but kept the same
names...
--
Regards, Frank van Bortel
Received on Mon Apr 28 2003 - 15:18:18 CDT
