Home » Open Source » MySQL » how to import oracle database in mysql database
how to import oracle database in mysql database [message #137051] Tue, 13 September 2005 00:31 Go to next message
ravivkumar
Messages: 34
Registered: April 2005
Location: chennai
Member

hi
i have exported users from oracle database ,

the content (tables present in that users) should be imported to mysql database .

what is procedure to exp oracle tables to mysql database.


Ravikumar.V
Re: how to import oracle database in mysql database [message #137115 is a reply to message #137051] Tue, 13 September 2005 06:10 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member



http://www.google.co.in/search?hl=en&q=move+Oracle+database+to+Mysql&btnG=Search&meta=
Re: how to import oracle database in mysql database [message #137686 is a reply to message #137051] Fri, 16 September 2005 02:18 Go to previous message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
The best tools to migrate tables definitions is "MySQL Migration Toolkit". You can get it at here http://www.mysql.com/products/tools/migration-toolkit/
You also can use it for migrating data.

If there are millions of rows, I suggest that you'd better dump oracle data into text files, column values seperate by 'Tab'. Then using mysql tool "mysqlimport" to import the data.

Hope this helpful.

Alexzeng
Previous Topic: Oracle9i replication to MYSQL 5.0
Next Topic: MySQL and Oracle SQL- the same function
Goto Forum:
  


Current Time: Sat Oct 31 08:58:42 CDT 2020