RE: Awfully annoying SQLLDR problem

This would be clean, but recall he did not want to "get into the larger issue of why I have to run it from one server vs. another."

Pay no attention to the man behind the curtain! <G>

|| -----Original Message-----
|| From: David A. Barbour [mailto:dbarbour_at_nucentrix.net]
|| Sent: Tuesday, April 24, 2001 12:28 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: Awfully annoying SQLLDR problem
||
||
|| Tom,
||
|| Just cogitating and ruminating...........
||
|| You mentioned that you're executing the load as part of a larger
|| procedure. Couldn't you execute a shell script that would
|| ftp the file
|| to the target server and run sqlldr via rsh -c? Another
|| thought would
|| be to have the target file on an NFS-mounted drive that could be
|| accessed by the target and have sqlldr kicked off on the target via a
|| trigger on a simple insert by the source into a
|| DATA_LOAD_REQUIRED table
|| on the target?
||
|| Regards,
||
|| David A. Barbour
|| Oracle DBA
||
|| blair_at_pjm.com wrote:
|| >
|| > 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).
|| --
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| --
|| Author: David A. Barbour
|| INET: dbarbour_at_nucentrix.net
||
|| 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).