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
Received on Sun Apr 27 2003 - 10:57:36 CDT
