This content has been marked as final. Show 6 replies
you have 50 sql tables in which format.....
if these are flat files you can use sql loader...
if these are in database then you can use export import utility with tables clause to only copy the tables.
You haven't said if this is a one-off copy of the data or if it is comething you want to do on a regular basis.
If it is a one-off move of the data then you could use the SQL*Developer migration workbench, see here for more details -
SQL*Developer main page -
Database Migration technology -
If it is something you want to do on a regular basis then you could use a gateway to make a connection between SQL*Server and Oracle and then copy or select from the remote tables.
The following page has more detail -
and this note if you have access to My Oracle Support -
Master Note for Oracle Gateway Products (Doc ID 1083703.1)
You could also use GoldenGate which allows real-time replication between Oracle and non-Oracle databases -