A lot of important and useful information is posted to litsupport each week. The following is a distilled summary, in the form of questions and answers.
Q. How to convert Oracle.DMP to a useable format, such as Excel?
- Go back to the client and asked if their IT department can export just the data you need to Excel. If that fails...
- Oradump will convert to Excel without any row limitations, as well to Access or MySQL;
- Oracle Express is free.You have to do the import from a command line like this (don't use the parentheses in the command): C:\>imp fp/fp file=(name of the DMP file).dmp full=y
This summary from the Litsupport Group postings created by the wonderful and talented members of the group has been culled by Mark Kerzner and edited by Aline Bernstein.