Viewing 2 posts - 1 through 2 (of 2 total)
The answer is to create a synonym within Oracle for the tables you want to view through the linked server
June 12, 2008 at 3:02 am
#827705
You can't do this with SQL plus, but what you could try is linking the Oracle database to SQL Server then doing a bulk insert from query analyser.
June 6, 2008 at 2:21 am
#825324