Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-LReceived on Mon Apr 23 2001 - 09:51:43 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
![]() |
![]() |