linked server to oracle

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » linked server to oracle

linked server to oracle

Rate Topic

Display Mode

Topic Options

Author

Message

bryan van ritter

Posted Wednesday, November 10, 2010 9:06 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, April 01, 2013 12:35 AM
Points: 82, Visits: 443

Hi,

i wonder if it is possible to create a table or a view over a linked server in an oracle database.

thanx in advance.

Bryan

Post #1018710

GSquared

Posted Wednesday, November 10, 2010 9:52 AM

SSCoach

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439, Visits: 9,569

I 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.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #1018764

samw-942736

Posted Monday, July 25, 2011 3:16 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:23 PM
Points: 7, Visits: 68

Actually 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.

Post #1147913

« Prev Topic | Next Topic »

Permissions