You can do this without a problem. Setup the Oracle drivers and tnsnames on the SQL Server then setup a linked server to the Oracle server. You can then access the objects on the Oracle server via the three part name converted to the four part format.
Code:
update OracleServer..Schema.Object a
SET a.Column = inserted.Column2
FROM inserted
WHERE a.Key = inserted.Key
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.