Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: can we view the data present in the Dump file.

Re: can we view the data present in the Dump file.

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: Mon, 4 Apr 2005 22:46:03 +0000 (UTC)
Message-ID: <d2sg3b$ivo$1@klatschtante.init7.net>

> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US