Stupid SQL*Loader tricks
From: Steve Emmett <semmett_at_adams.patriot.net>
Date: 1997/02/06
Message-ID: <5db7fn$1t7_at_washington.patriot.net>#1/1
Date: 1997/02/06
Message-ID: <5db7fn$1t7_at_washington.patriot.net>#1/1
[Quoted] [Quoted] Is there any way to overcome SQL*Loader's need to append a .dat to a file defined in INFILE?
[Quoted] As an example, I have a multitude of files of the form detail_xx (WITHOUT any .extension). In my control file I define INFILE = '/foo/bar/up/detail_xx'. When I invoke sqlload, I get an error that there is no file of that name (detail_xx). But, when I append .dat on the end of the detail_xx datafile, sqlload recognizes the INFILE definition.
I don't want to append a .dat to every file I need to load just to make sqlload happy - is there anyway to force sqlload to recognize EXACTLY the INFILE definition?
TIA
Steve
--
Steve J. Emmett semmett_at_patriot.net :::::::::::::::::::::::::::::::::::::::::::::::::::: "A mind that is stretched to a new idea never returns to its original dimension."Received on Thu Feb 06 1997 - 00:00:00 CET
----------------------------------------------------