| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Awfully annoying SQLLDR problem
Hi
Apparently, it is complaining with 942. I would set event '942 trace name context forever errorstack, level 15' in the init.ora file and restart the database, then reproduce the problem. Look at the trace file and errorstack will probably give you what table the server is trying to access.
Is there any triggers or snapshot logs on the table that you are trying to load ?
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies www.i2.com
blair_at_pjm.com
Sent by: To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
root_at_fatcity. cc:
com Subject: RE: Awfully annoying SQLLDR
problem
04/23/01
01:06 PM
Please
respond to
ORACLE-L
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: INET: Riyaj_Shamsudeen_at_i2.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 - 14:31:23 CDT
 |
 |