Re: SQLLDR won't accept files without .dat entension
From: DA Morgan <damorgan_at_x.washington.edu>
Date: Thu, 11 Nov 2004 20:13:37 -0800
Message-ID: <1100232740.363017_at_yasure>
Date: Thu, 11 Nov 2004 20:13:37 -0800
Message-ID: <1100232740.363017_at_yasure>
Todd Woods wrote:
> I'm trying to load files into the system.. only problem.. the files
> don't have a .dat extension..... it keeps appending the filename to
> filename.dat, and filename.dat isn't there...
>
> anyway to keep it from looking for a .dat extension, or any way to
> force it to use the filename without the extension????
>
> oracle 8 on unix or NT...
>
> thanks
> Todd
SQL Loader will accept anything if you list the file extension. If you don't then the default is .DAT.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Fri Nov 12 2004 - 05:13:37 CET