Wednesday, April 29, 2009

litsupport summary for the week ending on 04/26/09

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.

No comments: