Create a Migration Project, look for the Migrations menu item under Tools.
You want to do an offline data capture - this will stage your SQL Server data into some SQL*Loader files so they can be moved over into your new Oracle tables.
You can find some more info on this process here.
Hey Jeff, I'm new on this.
Sorry for my newbish question.
But If i use this tool migration, i will still have my SOURCE DB on SQL SERVER? and the copy of this on Oracle?
Because I don't want to remove it from SQL SERVER, i just need the data.
It'd be nice if we destroyed the source SQL database (joke), but we don't.
We just help you migrate it over to a new Oracle schema(s).