"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.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Tue Jul 08 2003 - 08:59:29 CDT
