Convert from MySQL to Oracle

Anon

I want to convert my MySql databse to Oracle . So can anybody help me how should i move .
If i use oracle with PHP will it work properly .

If u can help me please reply me at chanderjit@hotmail.com .

Thanks

CHanderjit

[deleted]

You can export your data as a delimited textfile which you can import into oracle.

And will it work... that's up to you!

Anon

How timely. You don't work for Oracle do you? Check out this link below...Oracle is providing a migration tool for just this task.

http://www.prnewswire.com/cgi-bin/stories.pl?ACCT=104&STORY=/www/story/01-31-2001/0001416415&EDATE=

Anon

How about the other way around? Converting from Oracle to MySQL?

Thanks,
Winnie

Anon

The other way is also possible to convert from Oracle to Mysql. Well i don't know how but this info i got from

http://www.mysql.com/news/article-51.html

Chanderjit

[deleted]

Sure, transporting data from one DB to another is easy.
The problem comes with things that are database-specific, like data-types and views and such.

Anon

Just a quick note. Test out PHP/Oracle combination, and make sure its stable before stopping mysql.

The last time I dealt with PHP/Oracle, it had some rather nasty side affect that made me switch to mysql.

Two things to look for:
(1) number of openfiles. Keep the site running with Oracle, and do something like
lsof | grep oracle | wc -l
to see how many open file there are at the moment.
(2) number of zombie or sleeping process. Do something like
ps -aux | grep oracle | wc -l
and keep an eye on how many process there are for the oracle user.

At least for me, when I stop one problem, the other one comes up.

-Will

Anon

Are there any utils that will convert an Oracle export so that I can import it to MySQL?