InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 07:26:15 GMT20http://www.sqlservercentral.com/Forums/Topic1018710-146-1.aspxActually both SQL server and Oracle does give you access to remote objects .SQl calls it Linked server objects, which links to external database fromwhich you can create your tables and views.Oracle provides the same functionality, in a little more complex way, and it is calld database links or db links, but you need a what is called a Oracle Trasnparent Gateway.Mon, 25 Jul 2011 15:16:03 GMTsamw-942736http://www.sqlservercentral.com/Forums/Topic1018710-146-1.aspxI don't know, but I know MS SQL won't allow remote object creation like that. I seriously doubt Oracle would. That would be a huge security hole potentially.Wed, 10 Nov 2010 09:52:18 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic1018710-146-1.aspxHi,i wonder if it is possible to create a table or a view over a linked server in an oracle database.thanx in advance.BryanWed, 10 Nov 2010 09:06:15 GMTbryan van ritter