Long Path Names for SQLLOADER

From: <sumanmehta_at_my-dejanews.com>
Date: Fri, 13 Nov 1998 00:54:28 GMT
Message-ID: <72g004$u9t$1@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 - 18:54:28 CST