Re: SQLLDR won't accept files without .dat entension
From: Turkbear <john.g_at_dot.spamfree.com>
Date: Tue, 09 Nov 2004 15:34:46 -0600
Message-ID: <opd2p05m9020u43rh8cbb6ch2fmgataru1_at_4ax.com>
Date: Tue, 09 Nov 2004 15:34:46 -0600
Message-ID: <opd2p05m9020u43rh8cbb6ch2fmgataru1_at_4ax.com>
lazytodd_at_hotmail.com (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
In my experience,Sqlloader does not care what the file name is, if you specify it using the INFILE option within the .CTL file.. Received on Tue Nov 09 2004 - 22:34:46 CET