No you are reading correctly. I have the data on a server with a 7.3.2.3
database and am using that databases' binary sqlldr to load into the 8.1.5
database. The problem is a timing issue. I need to execute the load from the
7.3.2.3 server as part of a larger script. I cannot ensure that the load will
be executed i a timely manner if it is run on the distant server.
Whether or not you agree with the timing issue I describe, I'd really appreciate
an answer to the Oracle problem. I don't want to get into the larger issue of
why I have to run it from one server vs. another. From an Oracle POV it should
work either way.
thanks,
..tom
> -----Original Message-----
> From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, April 23, 2001 12:27 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Awfully annoying SQLLDR problem
>
> Ok,maybe i am lazy or a poor reader, but are you
> using 732 sqlldr binaries to load an 815 db?
>
> Why not the 815 sqlldr binaries?
>
> I mean, it sounds like you have to ship data over the
> wire no matter what you do, so...why not use the latest
> version of the sqlldr bits?
>
>
>
> <==> -----Original Message-----
> <==> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> <==> Sent: Monday, April 23, 2001 11:10 AM
> <==> To: Multiple recipients of list ORACLE-L
> <==> Subject: Awfully annoying SQLLDR problem
> <==>
> <==>
> <==> I am executing a SQLLDR shell file from a server ::
> <==> sourceserv; RDBMS 7.3.2.3
> <==> AIX 4.3.2
> <==> into a database on server:: destserv; RDBMS 8.1.5 AIX 4.3.3
> <==> using a SQL*Net connect string destserv_destSID.
> <==>
> <==> This connect string is defined in the local tnsnames.ora
> <==> and works. I confirmed
> <==> this by doing sqlplus user/pass@destserv_destSID and
> <==> verifying that I am
> <==> connected to the correct instance.
> <==>
> <==> The target table exists. I am connecting as the owner
> <==> of the target table. That
> <==> owner has DBA.
> <==>
> <==> but when I run
> <==>
> <==> sqlldr userid=tabowner/pass@destserv_destSID
> <==> CONTROL=localcontrolfile.ctl
> <==> (controlfile is below)
> <==>
> <==> I get "SQL*Loader-925: Error while parsing a cursor (via ocisq3)
> <==> ORA-00942: table or view does not exist"
> <==>
> <==> Help! Does anyone have any ideas?
> <==>
> <==> tia,
> <==>
> <==> ..tom
> <==>
> <==> here's the controlfile
> <==>
> <==> LOAD DATA
> <==> INFILE data1.dat BADFILE load.bad
> <==> DISCARDFILE load.dsc
> <==> INSERT
> <==> INTO TABLE OWNER.TEST_LOAD
> <==> FIELDS TERMINATED BY ','
> <==> TRAILING NULLCOLS
> <==> (COL1,COL2,COL3)
> <==>
> <==>
> <==> --
> <==> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> <==> --
> <==> Author:
> <==> INET: [EMAIL PROTECTED]
> <==>
> <==> Fat City Network Services -- (858) 538-5051 FAX:
> <==> (858) 538-5051
> <==> San Diego, California -- Public Internet access /
> <==> Mailing Lists
> <==> ---------------------------------------------------------
> <==> -----------
> <==> To REMOVE yourself from this mailing list, send an E-Mail message
> <==> to: [EMAIL PROTECTED] (note EXACT spelling of
> <==> 'ListGuru') and in
> <==> the message BODY, include a line containing: UNSUB ORACLE-L
> <==> (or the name of mailing list you want to be removed
> <==> from). You may
> <==> also send the HELP command for other information (like
> <==> subscribing).
> <==>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mohan, Ross
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
