Do you get problems with one word directory names as well? A lot of programs
won't accept Program Files because it contains a space but will accept
Long_Directory_Name (for example). I don't know about SQL*Loader but
frequently you can get around the problem by enclosing the path in double
quotes,
ie. "c:\Program Files\cntrlfile.ctl".
sumanmehta_at_my-dejanews.com wrote in message
<72g004$u9t$1_at_nnrp1.dejanews.com>...
>Does anyone know how to overcome the Long Path Name problem
>in Oracle SQL*Loader ?
>
>Both sqlldr and sqlldr73 give an error if the path for a control file
>contains a directory name which is more than 8 characters.
>
>For. example:
>
>sqlldr73 user/passwrd_at_host c:\Program Files\cntrlfile.ctl
>
>gives me an error message.
>
>On the other hand,
>
>sqlldr73 user/passwrd_at_host c:\Program~1\cntrlfile.ctl
>
>works fine.
>
>I am passing the path name from Visual Basic.
>Does anyone know of a VB command which would
>convert the directory into an 8 character name recognized
>by SQL*Loader ?
>
>Thanks.
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Nov 12 1998 - 22:55:20 CST
