"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3f0ace42$0$18493$ed9e5944_at_reading.news.pipex.net>...
> "Marc Eggenberger" <marc.eggenberger_at_itc.alstom.com> wrote in message
> news:MPG.1974dcd8fedd80ab9896af_at_iww.cacti.ch.alstom.com...
> > Hi there.
> >
> > First:
> > Oracle 8.1.7 on Windows 2000 Adv Server
> >
> > I have an application here where some ppl want me to change a string
> > value.
> >
> > In one schema there are a few tables (about 150) and some of them have
> > character columns (mostly varchar2) with data in it. Some data is a
> > complete path on the filesystem like
> >
> > c:\data\t1\0001\uatr.trn
> > etc etc
> >
> > This is an old application and nobody knows what the excat layout is
> > (its not one I normaly have to care about).
> > They now moved the data to anther drive and this stupid application gets
> > all the path information from the database and wants the get those files
> > which does not work with the data on the new drive (stupid app ....)
> >
> > Is there an easy way to change the information?
>
> You are welcome to try OraGrep from
> www.niall.litchfield.dial.pipex.com/misc.htm It should generate a logfile to
> provide the basis for the updates that Brian provides.
i noticed you mentioned an oracle myhs presentation. anyway you could
post that? Its always good to make sure Im not spouting off the wrong
thing :).
Received on Wed Jul 09 2003 - 06:17:39 CDT
