Re: Stupid SQL*Loader tricks
Date: 1997/02/07
Message-ID: <32FACDDE.6D23_at_vip.cybercity.dk>#1/1
[Quoted] Steve Emmett wrote:
>
> Is there any way to overcome SQL*Loader's need to append a .dat to a file defined in INFILE?
>
> 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."
> ----------------------------------------------------
[Quoted] Have you tried /foo/bar/up/detail_xx.? Just a guess...
Finn
-- -------------------------------------------------------------------------------- Finn Ellebaek Nielsen Oracle Associated Senior Consultant E-mail: ellebuk_at_vip.cybercity.dk Ellebaek Consulting Mob. Phone: +45 20 32 49 25 Niels Ebbesens Vej 9, 3. th. [Quoted] Mob. Phone SMS: 20324925_at_sms.tdm.dk DK-1911 Frederiksberg C Private Phone: +45 33 25 34 50 Denmark -------------------------------------------------------------------------------- "Life is a beach and then you dive" "Divers do it deeper"Received on Fri Feb 07 1997 - 00:00:00 CET