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

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to