Re: Search for string in all tables in one schema

Hi Marc Eggenberger, thanks for writing this:
> 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?
>
> Something like
>
> for all tables in schema a
> do
> if table has varchar2 columns
> search for c:\data and replace it with d:\newdata
> endif
> loop
>
> I cant think of an easy way to do this. Maybe there is?
>
> Thanks for any help
>

Though it's not exactly what you're looking for, you might find some useful info in the following document (url will wrap):

http://asktom.oracle.com/pls/ask/f?p=4950:8:1090762::NO::F4950_P8 _DISPLAYID,F4950_P8_CRITERIA:350017644883, It's about how Tom set up the search "engine" on his AskTom site.

-- 
[:%s/Karsten Farrell/Oracle DBA/g]