| SQL*Loader related question. [message #74237] |
Fri, 15 October 2004 05:10  |
patrice
Messages: 5
Registered: October 2001
|
Junior Member |
|
|
When loading datas from a flat file into Oracle Database,I received the message:ORA-02371
<DL>
<DT><A id=ORA-02371 name=ORA-02371>[/url]"ORA-02371: Loader must be at least version string.string.string.string.string for direct path
<DD>
Cause: The loader being used is incompatible with this version of the kernel.
<DD>
Action: Upgrade your loader to at least the specified version or use the conventional path."</DD></DL>
--Load Data
infile 'file.data'
truncate
into table TABLE_NAME
FIELDS TERMINATED BY "|" TRAILING NULLCOLS
(column1,colum2,....columni)
and the Loader invocation like this:
sqlldr control=file.ctl,bad=file.bad,data=file.data,log=file.log direct=true userid=usernm/mypass@dev
How can I load this data?
The plattform ist LINUX-LIKE(cygwin),the Oracle version ist 8.
Thanks
|
|
|
|
| Re: SQL*Loader related question. [message #74239 is a reply to message #74237] |
Fri, 15 October 2004 07:05  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>The plattform ist LINUX-LIKE(cygwin),the Oracle version ist 8
So, you are invoking sqlldr from a client.
Make sure your client and server are SAME ORACLE RELEASES. sqlldr direct path has a certain restriction.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
