Yeah, the table DDL in an Oracle export file is in ascii format. I've used vi in the past to extract the DDL. You might be SOL though as far as reading the data is concerned.
--Walt -----Original Message----- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 11:42 AM To: [EMAIL PROTECTED] Subject: RE: Oracle .dmp to mySQL Except I don't have any access whatsoever to the Oracle server... All I have is a flat dmp file on a CD which has all the data embedded into this file... I have found a tool that will extract the table structure from this file... But will not extract the data Mike -----Original Message----- From: Tim Johnson [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 18:11 To: [EMAIL PROTECTED] Subject: RE: Oracle .dmp to mySQL There is a application out there that does this called SQLPorter made by Real Soft Studio (http://www.realsoftstudio.com). It might be worth the $$ if it saves you some time and hassle. It worked for me going from SQL Server 6.5 to MySQL 3.23. Hope this helps, Tim ----- Original Message ----- Sent: Monday, August 12, 2002 1:06 PM > Hope this helps you out a little on your conversion. > > Serge. > > > ----- Original Message ----- > From: "Mike Townend" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, August 12, 2002 9:29 AM > Subject: RE: Oracle .dmp to mySQL > > > > We don't have access to the Oracle server :( > > > > So as to a project handover to the client they just gave them the > > dmp file... > > > > Im currently downloading Oracle from the Oracle site but it's a > > major download :( > > > > Ive found a util that attempts to get the information from the dmp > > files but this is failing :( so was just putting a feeler out to see > > if anyone else had done this... So far I can recreate the table > > structure but cant extract the actual data from the file. > > > > TIA > > > > Mike > > > > -----Original Message----- > > From: Mikhail Entaltsev [mailto:[EMAIL PROTECTED]] > > Sent: Monday, August 12, 2002 14:17 > > To: Mike Townend; [EMAIL PROTECTED] > > Subject: Re: Oracle .dmp to mySQL > > > > > > Hi Mike, > > > > I am not sure, but as I remember Microsoft SQLServer has > > Import/Export utility (standard installation) that can import data > > from different sources (Oracle?! why not). > > > > Best regards, > > Mikhail. > > > > ----- Original Message ----- > > From: "Mike Townend" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Monday, August 12, 2002 3:09 PM > > Subject: Oracle .dmp to mySQL > > > > > > > Hi all, > > > > > > We have just recently inherited a web project from another company > > > who's DB was Oracle 8. And as such they have provided us with an > > > exported .dmp file of the database they were using... > > > > > > We are using mySQL as our DB backend... Does anyone know of any > > > tools > > > > > that will allow me to import this file into mySQL (or maybe SQL > > > Server > > > > > which we can then import to mySQL) > > > > > > MTIA > > > > > > Mike > > > > > > > > > > > > ------------------------------------------------------------------ > > > --- > > > Before posting, please check: > > > http://www.mysql.com/manual.php (the manual) > > > http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail > > > <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: > > > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > -------------------------------------------------------------------- > > - > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: > > http://lists.mysql.com/php/unsubscribe.php > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
