Home » RDBMS Server » Server Utilities » How to read an Oracle DMP file (Unix)
How to read an Oracle DMP file [message #473727] Tue, 31 August 2010 08:21 Go to next message
rakeshsu30
Messages: 3
Registered: August 2010
Location: Chennai
Junior Member

Hello There,

I have been trying to figure out, how do I check for the data in the DMP file.

Actually I have done some search but with no result. I have to check the oracle DMP file which is being sent through the EXP utility from oracle and have to search for a pattern in the file. If the pattern in found then send a mail.

I have tried using the GREP on the DMP and SED but as the lines are longer than expected these are not providing desired results..

Please help out.

Regards,
Re: How to read an Oracle DMP file [message #473728 is a reply to message #473727] Tue, 31 August 2010 08:26 Go to previous messageGo to next message
cookiemonster
Messages: 11203
Registered: September 2008
Location: Rainy Manchester
Senior Member
What exactly are you trying to check for?
The data in dump files isn't really designed to be grepped - it's binary.
Re: How to read an Oracle DMP file [message #473732 is a reply to message #473727] Tue, 31 August 2010 08:48 Go to previous messageGo to next message
wvu1999
Messages: 38
Registered: April 2007
Member

Toad can parse and display EXP .DMP files, not yet for DataPump .DMPs
http://www.toadworld.com/Products/ToadforOracle/ProductTutorials/TutorialV85/tabid/276/Default.aspx#Export
Re: How to read an Oracle DMP file [message #473734 is a reply to message #473732] Tue, 31 August 2010 08:55 Go to previous messageGo to next message
BlackSwan
Messages: 23059
Registered: January 2009
Senior Member
>how do I check for the data in the DMP file.
imp SHOW=Y
Re: How to read an Oracle DMP file [message #473735 is a reply to message #473727] Tue, 31 August 2010 09:11 Go to previous messageGo to next message
TinchoGomez
Messages: 11
Registered: January 2010
Location: Santa Fe - Argentina
Junior Member

imp file=file.dmp show=Y

Is necesary GRANT'S as SYSDBA.
Re: How to read an Oracle DMP file [message #473738 is a reply to message #473735] Tue, 31 August 2010 09:16 Go to previous messageGo to next message
BlackSwan
Messages: 23059
Registered: January 2009
Senior Member
>Is necesary GRANT'S as SYSDBA.
I am not clear if line above is statement or question.
GRANT is done to USER or ROLE and "SYSDBA" is neither ROLE nor USER.
Re: How to read an Oracle DMP file [message #474029 is a reply to message #473738] Thu, 02 September 2010 02:23 Go to previous messageGo to next message
rakeshsu30
Messages: 3
Registered: August 2010
Location: Chennai
Junior Member
I just do not want the whole data to be checked but then if the dump file contains any sample of the pattern. Then I have to just know that. As mentioned I have used grep and sed but as mentioned grep cannot be used in this case.

Hope any other method of searching through binary file in Unix could be possible. I just did cat on the DMP file and saw some garbled values and the pattern I needed. So though if the values can be seen , then defintely can be used for pattern matching..
Re: How to read an Oracle DMP file [message #474030 is a reply to message #474029] Thu, 02 September 2010 02:27 Go to previous messageGo to next message
Michel Cadot
Messages: 59810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't.

Regards
Michel
Re: How to read an Oracle DMP file [message #474061 is a reply to message #474029] Thu, 02 September 2010 08:05 Go to previous messageGo to next message
joy_division
Messages: 4546
Registered: February 2005
Location: East Coast USA
Senior Member
rakeshsu30 wrote on Thu, 02 September 2010 03:23
I just did cat on the DMP file and saw some garbled values and the pattern I needed. So though if the values can be seen , then defintely can be used for pattern matching..


Incorrect. If it is a binary file, by sheer luck (good or bad), you may see the pattern you are looking for which can be just a bunch of random letters/numbers that happen to match your pattern. to search for a "pattern" in a dump file is just plain silly.
Re: How to read an Oracle DMP file [message #474069 is a reply to message #474061] Thu, 02 September 2010 09:23 Go to previous messageGo to next message
Michel Cadot
Messages: 59810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
to search for a "pattern" in a dump file is just plain silly.

I'm surprised to not be the first one to post this sentence. Laughing

Regards
Michel
Re: How to read an Oracle DMP file [message #474133 is a reply to message #474030] Fri, 03 September 2010 00:54 Go to previous messageGo to next message
rakeshsu30
Messages: 3
Registered: August 2010
Location: Chennai
Junior Member
> imp SHOW=Y

I tried the same option, but I cannot get the data which is present in the file. Can you help me get the exact syntax of the command and how to interpret it.

Re: How to read an Oracle DMP file [message #474143 is a reply to message #474133] Fri, 03 September 2010 02:22 Go to previous message
Michel Cadot
Messages: 59810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
imp help=y

Regards
Micehl
Previous Topic: IMP-00041: Warning: object created with compilation warnings
Next Topic: Counting the position of data in fixed format.
Goto Forum:
  


Current Time: Thu Nov 27 07:53:52 CST 2014

Total time taken to generate the page: 0.09006 seconds