RE: 10G client talking to 9i DB with SQL LOADER using the direct load option

Hi Larry,  

Check MetaLink Doc ID 444663.1  

It's not the exact error you're seeing, but it unambiguously states that you can't use 10g client to direct load into 9i database.    

Here's a quote from the document:

The client version must be the same or earlier than the server version, and both must be 9i or later for direct path load. Therefore,direct path load cannot be used to load data from 10g client into 9i database. In addition, a direct path load from 9.2 client into 9.0.1 database is not supported.      

--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059  or +1.800.521.0600 x 4059
mark.bobak_at_il.proquest.com <mailto:mark.bobak_at_il.proquest.com> 
www.proquest.com <http://www.proquest.com> 
www.csa.com <http://www.csa.com> 

ProQuest...Start here. 

 

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Wolfson Larry -
lwolfs
Sent: Wednesday, October 17, 2007 4:19 PM
To: oracle-l
Subject: 10G client talking to 9i DB with SQL LOADER using the direct
load option

 

HI Guys,

                I've got an app server with a 10G client.  The app guys
what to use the direct load option with SQLLOADER going to a 9I DB.

Seems the 10G view has an extra column in it that 9i doesn't have.

Is there a way around this without installing a 9i client or using a
conventional load as OSS says is the solution?

Like changing the 9i view just for this user?

 Here are the error message that are getting generated when we invoke
sqlloader using the direct load option. 

ORA_F901,0: SQL*Loader-925: Error while uldlpim: OCIStmtExecute 

ORA_F901,0: ORA-00904: "MESSAGE_NUM": invalid identifier 

Using the conventional load returns no error.  

    TIA

    Larry 



************************************************************************

*

The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally privileged.
 
If the reader of this message is not the intended recipient, you are 
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
 
If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.
 
Thank you.


************************************************************************

*


--
http://www.freelists.org/webpage/oracle-l