Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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).Received on Mon Apr 23 2001 - 10:55:27 CDT
![]() |
![]() |