| How to read an Oracle DMP file [message #473727] |
Tue, 31 August 2010 08:21  |
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 #474029 is a reply to message #473738] |
Thu, 02 September 2010 02:23  |
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 #474061 is a reply to message #474029] |
Thu, 02 September 2010 08:05 |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
rakeshsu30 wrote on Thu, 02 September 2010 03:23I 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.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
