Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Alert !!!! Oracle export through pipes and compressions !!!!!
bsarma_at_basit.com (BN.Sarma) wrote in message news:<e20868e8.0302060925.6dd2da94_at_posting.google.com>...
> Greetings Jonothan and Pete,
>
> Is there any way or any tool I can salvage the data from this .dmp file.
>
>
> Regards & thanks
> BN
Since you are hosed by Oracle, any data may be corrupted.
With that in mind, however, unix has a strings command which, while very dangerous for this sort of activity, may indeed allow you to get at least character data back. Depending on which tools you use, sometimes long line lengths (ie, lots of columns) can burn you with this method.
The other export bug which has been known for a few months I believe simply loses repetitive data.
jg
-- @home is bogus. sigblog.Received on Thu Feb 06 2003 - 19:43:55 CST