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.
-- Postgresql & php tutorials http://www.designmagick.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
