RE: Awfully annoying SQLLDR problem

Thank you ever-so-much to Tim, Kirk, Peter, and especially Kirti for your intelligent responses. I'm going to open a TAR on Metalink. I'll probably get the quick and easy response "We don't support it anymore". I'm no fan of Oracle but would not blame them for giving me that response.

We will have upgraded our source database to 8.1.6.2 by mid July. Perhaps my project will have to wait till then.

thanks again,

..tom

> -----Original Message-----
> From: Tim Sawmiller [SMTP:sawmillert_at_state.mi.us]
> Sent: Monday, April 23, 2001 3:08 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Awfully annoying SQLLDR problem
>
> The missing verb is "think", as in "I don't think you can avoid...".
>
> >>> sawmillert_at_state.mi.us 04/23/01 02:46PM >>>
> 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).
> --
> 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).

-- 
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).