Hi,
In oracle database links are avilable but the use is to connect remote oracle database. but in oracle you can write the table contents to a file and in sqlserver using BULKINSERT(or import wizard) you can copy the data.
And also using import/export wizard in SQLSERVER you can copy or move data from/to any database using odbc drivers.

with regards,
v.sathishkumar