Re: How do you search through multiple tables?

On Tue, 18 Feb 2003 23:34:37 +0100, E. Navarro wrote (in message <b86354ef.0302181434.32eb8152_at_posting.google.com>):

> Oracle 8.1.7.4 EE
> Solaris 7
>
> All,
>
> I am trying to figure out a way to search through multiple tables (over
> 50)for
> a particular piece of data. I had a user enter some data into a table a
> while
> back, and can't figure out which table he entered the data. Does anyone
> have a script that can traverse through table columns and locate data (in my
> case it was a string)?
>
> TIA,
> Daniel

use exp and grep on the dmp file.

-- 
With kind regards,
Ronald
http://ronr.nl/unix-dba