Re: Large loader file

bgt0990 wrote:

> I have a 280MB loader file that was produced with Foxpro, in the file every
> instance of what should be a NULL was converted by Foxpro to a space. So I
> have the sequence ,^space^, when it should be ,^^,
>
> I don't have access to Foxpro to see if this can be fixed there. The file
> is way to big for any editor we have tried to do a search and replace with,
> even if the editor will handle the file size they can't handle a search and
> replace that big. (even my trusty Vi choked).
>
> Is there an easy way to fix this with SQL_loader or a way to do this in SQL
> against the entire schema of 60 some odd tables??
>
> Any help would be appreciated
> Barry
>
> -----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
> http://www.newsfeed.com The #1 Newsgroup Service in the World!
> -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----

Load the data in with SQL*Loader and use the TRIM function in the control file.

Daniel Morgan Received on Mon Jul 08 2002 - 21:26:53 CEST