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

> is there any way that we can view the data present in the
>Dump file.

Create an extract of the the file using the unix strings command. Also, od -c works with greater detail. You can pipe the output into more and use normal search commands to get to where you want to be in the file. For example, I just did a strings jjj.exp|more, and I can see the version, schema and some other things, then a create table statement. At the end of the create table statements it has VALUES (:1,:2 and so forth, like normal bind variables in an insert statement.  After that, I see the values for each column in the row (except numbers are scrunchied - that's where od becomes useful). And I can /10059 to get to that value. And ?CREATE TAB to back up and find out which table 10059 is in.

I can tail the file to see two lines of EXIT at the end.

You can also use some editors to look at the file, assuming they can handle the size file, but be careful not to try to write it out, most editors will screw it up. vi does not work.

Of course, you can import it into another schema and look at it. Depends what you actually want to do.

jg

--
@home.com is bogus.
"COTS, in many cases, should be an obscenity." - Daniel Morgan
But at least it's a _cheap_ obscenity!  :-)