RE: Awfully annoying SQLLDR problem

It is not my purpose here to discuss issues not related to Oracle. The 7.3.2.3 database is inside a firewall - not so the 8.1.5 database. Our corporate standard for server file exchange is MQSeries though I could probably get an exemption to use rsh.

In my TAR I wrote :One Oracle workaround I could try is running the sqlldr against the 7.3.2.3 database into a view of a table in the 8.1.5 database through a DB link. I will try that if there is no quick easy solution to my problem."
Oracle's reply is this. (their syntax - not mine) "I think you may try the workaround you mentioned above.
At this time, there is no quick around solution. It will take longer process to test this case and if it's not work we have to file a new bug. This process will take awhile. Let me know if your workaround work."

So I guess I'll try my workaround.
thanks all,

..tom

> -----Original Message-----
> From: Mohan, Ross [SMTP:MohanR_at_STARS-SMI.com]
> Sent: Tuesday, April 24, 2001 2:57 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 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).

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