Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!o13g2000cwo.googlegroups.com!not-for-mail
From: fitzjarrell@cox.net
Newsgroups: comp.databases.oracle.server
Subject: Re: can we view the data present in the Dump file.
Date: 4 Apr 2005 00:33:27 -0700
Organization: http://groups.google.com
Lines: 43
Message-ID: <1112600007.085469.202230@o13g2000cwo.googlegroups.com>
References: <801c55451ec04b059d412d670e91d2ca@DBMonster.com>
NNTP-Posting-Host: 68.95.47.225
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1112600011 3394 127.0.0.1 (4 Apr 2005 07:33:31 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 4 Apr 2005 07:33:31 +0000 (UTC)
In-Reply-To: <801c55451ec04b059d412d670e91d2ca@DBMonster.com>
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: o13g2000cwo.googlegroups.com; posting-host=68.95.47.225;
   posting-account=B_KC8Q0AAADcSTVy4DZ59utFaLrVLOo4
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:239581


Deepa balu via DBMonster.com wrote:
> 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.
>
> --
> Message posted via http://www.dbmonster.com

It is pretty simple, really:

imp user/pass file=<your dump file here> full=y show=y log=<your log
name here>

where user/pass is a username and password valid for your database.  Of
course the database need not be local:

imp user/pass@mydb file=<your dump file here> full=y show=y log=<your
log name here>

This, of course, can produce a tremendous amount of output.  A simpler
solution is:

imp user/pass file=<your dump file here> full=y indexfile=<your
filename here>

or, for a remote connection:

imp user/pass@mydb file=<your dump file here> full=y indexfile=<your
filename here>

This will generate a file of create table/create index statements on
the machine initiating the connection which you may browse with any
text editor at your leisure.


David Fitzjarrell