| sqlldr problems please help [message #71027] |
Wed, 28 August 2002 06:14  |
Helena
Messages: 42
Registered: February 2002
|
Member |
|
|
I'm trying to use sqlldr with oracle 8170 on sun server and I get this problem
sqlldr
ld.so.1: sqlldr: fatal: libclntsh.so.8.0: open failed: No such file or directory
Killed
please help
thanks
Helena
|
|
|
|
|
|
| Re: sqlldr problems please help [message #71038 is a reply to message #71027] |
Thu, 29 August 2002 07:11  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
Your environment variables should look something like:
ORACLE_HOME=/oradb/d1/app/oracle/product/8.1.7
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
PATH=$ORACLE_HOME/bin:/usr/bin:/etc:/usr/ccs/bin:/usr/openwin/bin:/usr/ucb:/usr/sbin:/usr/local/bin:.
SHLIB_PATH=$ORACLE_HOME/lib
Note: I used $ORACLE_HOME to shorten the view. Use full path in the above example.
Your full directory liting on this file should look like this:
$ <mess> /oradb/d1/app/oracle/product/8.1.7/lib> ll libclntsh.so*
lrwxrwxrwx 1 oracle dba 16 May 14 12:50 libclntsh.so -> libclntsh.so.8.0*
-rwxr-xr-x 1 oracle dba 9579128 May 14 12:50 libclntsh.so.8.0*
|
|
|
|
| Re: sqlldr problems please help [message #71700 is a reply to message #71027] |
Mon, 23 December 2002 01:57 |
prathima
Messages: 1
Registered: December 2002
|
Junior Member |
|
|
this is my code
i want to import data from text file and put date in
yyyymmdd format..
so i want the syntax for date....
load data infile brand.txt
this is my control file
error is syntax for date
append into table BRDMST
(
BRD_CODE position (1:5) char,
BRD_PKG position (6:8) char,
BRD_DATE position (9:16) date('yyyymmdd'),
BRD_NAME position (104:133) char)
|
|
|
|
| Re: sqlldr problems please help [message #72719 is a reply to message #71038] |
Wed, 01 October 2003 09:44 |
shilpi
Messages: 2
Registered: October 2003
|
Junior Member |
|
|
I have the same problem.
bash-2.03$ echo $ORACLE_HOME
/data/app/oracle/product/9ias2
bash-2.03$ sqlldr
ld.so.1: sqlldr: fatal: libclntsh.so.9.0: open failed: No such file or directory
Killed
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
