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