Re: Oracle's dump to MySQL

Extract to csv/XML? Bastien Sent from my iPod On Apr 3, 2009, at 5:10, 9el <lenin@phpxperts.net> wrote:

On Fri, Apr 3, 2009 at 3:47 AM, Chris <dmagick@gmail.com> wrote:

9el wrote:

I found this command from one guy for importing Oracle's dump to MySQL Shell> mysql -uroot db_name -vvf < oracle_dump.dmp But, v is for verbose and f is for force continuation. Anyone worked with Oracle and MySQL?

Yep, and there's no way that will ever work except for the very simplest table and data. The datatypes are different (mysql doesn't have varchar2, timestamp formats are different though oracle lets you change that). You'll need to do a schema-only dump, convert it to the mysql format, then worry about converting the data.

Yes, before writing the mail I had this confusion but as my max_packet_allowed was default to 16M I couldn't have been able to continue with 28M dump from Oracle. Now that I have the schema in MySQL already. What can I do to get data only from Oracle's DB? There are lots of software tools out there but I want to learn it from the base. I cant afford to buy any software either.

-- Postgresql & php tutorials http://www.designmagick.com/