Migration from Oracle to MySQL or PostgreSQL

I want to migrate the data source of my Java web application from oracle to either MySQL or PostgreSQL. Oracle 开发者_运维技巧database size is huge and contains Large objects as well. Please suggest which would be the better choice? Please explain with some issues, example and points.

PostgreSQL is much more similar to Oracle than MySQL is. Significant difference still exist, but you'd probably find it to me an easier migration, and more similar behaviour by the database.

Large objects as BLOB might give you some problems as Oracle has some vendor specific implementation which is often used in Java code. I.e check you import statements where BLOB is used. For some more see here: http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html