RE: chk integrity of a .dmp exp
Create a log file of the export and scan that logfile for any errors reported by the export process. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Thursday, January 08, 2004 12:59 AM To: Multiple recipients of list ORACLE-L Hi, What is the procedure to check the integrity of a exported .dmp file? I have: an exported .dmp file of a critical database. I want: to check the integrity, the contents, whether it can be successfully restored. I already know about: creating another test database and trying to import this exported file. This is not what I am looking for. Is there a utility that displays the contents of a .dmp in tree format AND verify the data integrity that the ,dmp can be successfully restored? Thanks L. MOhan Arun ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: chk integrity of a .dmp exp
Quick answer... do a strings on the file... strings yourfile.dmo the first line should be EXPORT:Vversion number the last line should be EXIT In between you should see stuff you recognize. If all of that is in place, you have a valid .dmp file Of course, I am assuming Unix. Of course I am. HTH, Bambi. -Original Message- Sent: Wednesday, January 07, 2004 11:59 PM To: Multiple recipients of list ORACLE-L Hi, What is the procedure to check the integrity of a exported .dmp file? I have: an exported .dmp file of a critical database. I want: to check the integrity, the contents, whether it can be successfully restored. I already know about: creating another test database and trying to import this exported file. This is not what I am looking for. Is there a utility that displays the contents of a .dmp in tree format AND verify the data integrity that the ,dmp can be successfully restored? Thanks L. MOhan Arun __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: L. Mohan Arun INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: chk integrity of a .dmp exp
The SHOW option for import might be helpful Waleed -Original Message- Sent: Thursday, January 08, 2004 12:59 AM To: Multiple recipients of list ORACLE-L Hi, What is the procedure to check the integrity of a exported .dmp file? I have: an exported .dmp file of a critical database. I want: to check the integrity, the contents, whether it can be successfully restored. I already know about: creating another test database and trying to import this exported file. This is not what I am looking for. Is there a utility that displays the contents of a .dmp in tree format AND verify the data integrity that the ,dmp can be successfully restored? Thanks L. MOhan Arun __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: L. Mohan Arun INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).