How to migrate from sqlserver to Oracle any information
This might help: http://www.swissql.com/products/sqlserver-to-oracle/sql-server-to-oracle.html
"SwisSQL - SQL Server to Oracle Migration Tool helps you migrate MS SQL Server Transact-SQL Procedures, Functions and Triggers to Oracle PL/SQL language. When enterprises migrate from MS SQL Server to Oracle, application migration is one of the tedious tasks and there are no good tools which can ease the process of migrating MS SQL Server Stored Procedures to Oracle PL/SQL. Using SwisSQL - SQL Server to Oracle Migration Tool and through AdventNet's superior support, enterprises can realize significant time and cost savings during the migration and testing process."
This also looks like it might work:http://www.spectralcore.com/fullconvert/tutorials/convert-mssql-sql-server-to-oracle.php
"migrate Microsoft SQL Server database to Oracle in under five minutes"
# Full Unicode support
# Creates all data, indexes and foreign keys
# Data throughput of thousands of records/sec
# Easily handles tens of gigabytes of data
# Advanced command-line support
# Built-in scheduler for recurring conversions
# BLOB and MEMO fields are fully supported
# Runs on all Windows versions