RE: Awfully annoying SQLLDR problem

I don't you *can* avoid the larger issue. Oracle 8 has undergone some radical changes underneath the covers. I would expect SQLLDR to have changed just as radically...

>>> blair_at_pjm.com 04/23/01 02:06PM >>>
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:MohanR_at_STARS-SMI.com]
> 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: blair_at_pjm.com [mailto:blair_at_pjm.com]
> <==> 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_at_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_at_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: blair_at_pjm.com
> <==>
> <==> 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: ListGuru_at_fatcity.com (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: MohanR_at_STARS-SMI.com
>
> 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: ListGuru_at_fatcity.com (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: blair_at_pjm.com 

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: ListGuru_at_fatcity.com (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: Tim Sawmiller
  INET: sawmillert_at_state.mi.us

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: ListGuru_at_fatcity.com (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).