Re: Loading Data from text files
From: Chris Leonard <s_p_a_m_chris_at_hotmail.com>
Date: Mon, 4 Aug 2003 16:17:39 -0500
Message-ID: <U3AXa.46$J44.34450_at_news.uswest.net>
Date: Mon, 4 Aug 2003 16:17:39 -0500
Message-ID: <U3AXa.46$J44.34450_at_news.uswest.net>
Hi Chris,
After building the correct control file, you can easily write a batch file that *any* user should be able to execute. If the file layout specs change at a later time, you might want to change the control file yourself, or just train the users in how to do it.
-- Cheers, Chris ___________________________________ Chris Leonard, The Database Guy http://www.databaseguy.com Brainbench MVP for Oracle Admin http://www.brainbench.com MCSE, MCDBA, OCP, CIW ___________________________________ "Chris Hughes" <chris_hughes22_at_yahoo.co.uk> wrote in message news:969fd5ae.0308040802.2cda842c_at_posting.google.com...Received on Mon Aug 04 2003 - 23:17:39 CEST
> Hi All
>
> I have been given a project to load data to a database directly from
> text files.
>
> From stuff I've read SQL Loader sounds like a good route to take, it
> seems relatively easy to use too, my question is what is this like to
> implement on a customer site, would it be usesable by a user with no
> technical know how?
>
> OR
>
> Would you just write your own import routine and control it all myself
>
> Thanks
>
> Chris