Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: can we view the data present in the Dump file.
> I want to search a string within the Data of few tables.
> I do not know the particular Tablename or the column name.
>
> I have a dump file .Just like how we can view the DDL of the Objects of
> dump file ,,,,,,, is there any way that we can view the data present in the
> Dump file.
I have once written some PL/SQL that does this. You can find it on my home page: http://www.adp-gmbh.ch/ora/misc/find_in_tables.html It searches for a given string within %char% tables in your schema. Possibly, you need to tweak the function a bit.
hth
Rene
-- Rene Nyffenegger http://www.adp-gmbh.ch/Received on Mon Apr 04 2005 - 17:46:03 CDT