This content has been marked as final. Show 2 replies
You have quite a few options.
1. Use BCP/SQL*Loader utilities to migrate data sets that are very large. Definition of large varies of course.
2. Use SQLDeveloper to migrate data for small tables
3. You can also use any ETL tools that you use today for migrating large tables
4. You can also use database gateways
Typically option #1 and #2 are the most commonly used methods.
I also use GoldenGate to replicate a small SQL DB to Oracle 11gR2