Migrating from SQL Server to Oracle

Looks like migration between databases can be quite a painful job indeed! There are bound to be issues around data types, temporary tables and stored procedures returning result sets to start with. The Oracle Migration Work Bench should be able to do a decent job though (it would be pointless to attempt a manual migration). These docs should cover all the areas where migration is likely to be an issue. An older version of the migration whitepaper is here. If you are estimating for a migration, this whitepaper is a MUST READ!

This blog may be useful for general tips and issues regarding migrations (the person has moved out of Oracle now and I haven't read the blog mysef).