Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: migrating data from mysql to oracle.
On Fri, 3 Mar 2006 08:29:14 +0100, JAI via DBMonster.com wrote
(in article <5cb0e62d1248c_at_uwe>):
> Can anyone tell me how to migrate tables from mysql to oracle ? I have done
> it using the oracle migration tool.Is it possible thru SQldump ?
If you are able to create some kind of ascii file per table you can easily read them into oracle using sqlloader or external table. You could also try HS (Heterogenous services) to connect from the oracle database directly to the mysql database and use a databaselink to pump it all over.
-- With kind regards / met vriendelijke groeten, Ronald http://ciber.nl http://homepage.mac.com/ik_zelf/oracleReceived on Fri Mar 03 2006 - 03:59:49 CST