Large loader file

From: bgt0990 <btighe_at_neometrics.com>
Date: Mon, 8 Jul 2002 15:19:30 -0400
Message-ID: <3d29e3e9_6_at_corp-goliath.newsgroups.com>



[Quoted] [Quoted] I have a 280MB loader file that was produced with Foxpro, in the file every [Quoted] [Quoted] instance of what should be a NULL was converted by Foxpro to a space. So I [Quoted] have the sequence ,^space^, when it should be ,^^,

[Quoted] I don't have access to Foxpro to see if this can be fixed there. The file [Quoted] is way to big for any editor we have tried to do a search and replace with, [Quoted] even if the editor will handle the file size they can't handle a search and [Quoted] replace that big. (even my trusty Vi choked).

[Quoted] [Quoted] Is there an easy way to fix this with SQL_loader or a way to do this in SQL [Quoted] against the entire schema of 60 some odd tables??

Any help would be appreciated
Barry

[Quoted] [Quoted] [Quoted] -----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! [Quoted] [Quoted] -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Mon Jul 08 2002 - 21:19:30 CEST

Original text of this message