While the extension on the file isn't set in stone, many people add the .dmp extension to files created with the Oracle exp utility.
You can use a third party utility call nxtract (http://www.elmbronze.co.uk/nxtract/index.htm) to convert exp files into tab delimited files. The eval version only does 5k rows of data though. I've never used, nor do I endorse nxtract. I just found it while googling around looking for a tool to process oracle exp files. It might be easier to just connect to the oracle instance (if it still exists) using perl and extracting the data to insert statements that way. On Thu, 22 Jul 2004 15:53:39 -0700 (PDT), David Blomstrom <[EMAIL PROTECTED]> wrote: > --- Victor Pendleton <[EMAIL PROTECTED]> wrote: > > Are you referring to an Oracle .dmp export file? If > > so you will also need to > > do some parsing. > > * * * * * * * * * * > > I don't know; this is the first time I've tangled with > a .dmp file. Someone told me it must have come from an > Oracle system, because .dmp files are associated with > Oracle. But I may have been misinformed. > > __________________________________ > Do you Yahoo!? > Vote for the stars of Yahoo!'s next ad campaign! > http://advision.webevents.yahoo.com/yahoo/votelifeengine/ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
