Re: Oracle DMP to mySQL -- Possible???
Oops, I stand corrected. -Sheeri On 10/25/05, Jason Martin [EMAIL PROTECTED] wrote: On Tue, Oct 25, 2005 at 04:22:01PM -0400, sheeri kritzer wrote: What you need is the table schemas and the data. Oracle doesn't have SHOW CREATE TABLE like mysql does. Furthermore, Oracle also doesn't The oracle-supplied DBMS_METADATA package can do this for you. -Jason Martin -- Silence is more eloquent at times than words. This message is PGP/MIME signed. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Oracle DMP to mySQL -- Possible???
I have some data that has been dumped from Oracle into what appears to be a proprietary text file... It is not delimited into a format that I can just import into mysql (easily). The IT guy has provided me an outline of the dump.. ie; SQL describe isup051024; Name Null?Type - CCS_UNITIDNOT NULL CHAR(7) DIS_POSI_TION NOT NULL CHAR(3) OPCCHAR(11) CIRCUIT_ID_CODENUMBER etc.. etc.. etc.. Does mysql have a way to import these Oracle dumps easily?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle DMP to mySQL -- Possible???
that looks like a spool file from sqlplus. does it have the data too or just a bunch of describes? if this is what he gave you he is either severly clue-challenged or trying to sabotage you (my $ on later though they're not mutually exclusive). you could write a perl program to parse this into something intelligable (to mysql) but it would be a fair amount of work. On 10/25/05, Cummings, Shawn (GNAPs) [EMAIL PROTECTED] wrote: I have some data that has been dumped from Oracle into what appears to be a proprietary text file... It is not delimited into a format that I can just import into mysql (easily). The IT guy has provided me an outline of the dump.. ie; SQL describe isup051024; Name Null? Type - CCS_UNITID NOT NULL CHAR(7) DIS_POSI_TION NOT NULL CHAR(3) OPC CHAR(11) CIRCUIT_ID_CODE NUMBER etc.. etc.. etc.. Does mysql have a way to import these Oracle dumps easily?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle DMP to mySQL -- Possible???
What you need is the table schemas and the data. Oracle doesn't have SHOW CREATE TABLE like mysql does. Furthermore, Oracle also doesn't have fun tools like AUTOINCREMENT -- you're going to want to know what the code is for any triggers on the data, because in order to do AUTOINCREMENT in oracle you use a trigger. So I think you're stuck on the Oracle DDL - MySQL DDL. Ask your Oracle DBA to give you a sample of the data, too (is it just a comma-separated, enclosed-by-something file? It's not likely going to be a series of INSERT statements, like mysqldump gives), AND the full code of all the triggers. -Sheeri On 10/25/05, Sid Lane [EMAIL PROTECTED] wrote: that looks like a spool file from sqlplus. does it have the data too or just a bunch of describes? if this is what he gave you he is either severly clue-challenged or trying to sabotage you (my $ on later though they're not mutually exclusive). you could write a perl program to parse this into something intelligable (to mysql) but it would be a fair amount of work. On 10/25/05, Cummings, Shawn (GNAPs) [EMAIL PROTECTED] wrote: I have some data that has been dumped from Oracle into what appears to be a proprietary text file... It is not delimited into a format that I can just import into mysql (easily). The IT guy has provided me an outline of the dump.. ie; SQL describe isup051024; Name Null? Type - CCS_UNITID NOT NULL CHAR(7) DIS_POSI_TION NOT NULL CHAR(3) OPC CHAR(11) CIRCUIT_ID_CODE NUMBER etc.. etc.. etc.. Does mysql have a way to import these Oracle dumps easily?? -- 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]
Re: Oracle DMP to mySQL -- Possible???
On Tue, Oct 25, 2005 at 04:22:01PM -0400, sheeri kritzer wrote: What you need is the table schemas and the data. Oracle doesn't have SHOW CREATE TABLE like mysql does. Furthermore, Oracle also doesn't The oracle-supplied DBMS_METADATA package can do this for you. -Jason Martin -- Silence is more eloquent at times than words. This message is PGP/MIME signed. pgpLVYHOkxNxK.pgp Description: PGP signature
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
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
RE: Oracle .dmp to mySQL
I think it will be very difficult to do. In Oracle export files the data is written in Oracle's own proprietary binary format. I don't know of any tools other than Oracle's own import utility that is able to read the .dmp file. You may need to get them to send you a .csv file instead. --Walt Weaver Bozeman, Montana -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 7:10 AM To: [EMAIL PROTECTED] 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
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
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
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
RE: Oracle .dmp to mySQL
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
