SQL Server 2005 Indexed View on Oracle Table? 1

[fuzzyocelot]

Is it possible to create an indexed view in SQL Server 2005 on a table that resides in an Oracle database? If so, how would you go about doing so? Using a linked server?

Thanks!

 

[mrdenny]

You probably won't be able to do this. When you have an indexed view the SQL Server needs to know about each time data has changed on the base table. When the tables are local this is easy. When the tables are remote, probably not so much.

Denny
MVP
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)

My Blog

 

[fuzzyocelot]

Thanks for replying. The task has been given to our Oracle DBA since she knows both Oracle and SQL Server. She feels it will work just fine. Guess we'll see what happens.

Thanks!