Oracle offers the Migration Workbench tool to convert SQL Server databases to Oracle. I've never needed to use it so I cannot tell you how effective or easy to use it is. More information here:

http://otn.oracle.com/tech/migration...nch/index.html