November 10, 2010 at 9:06 am
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
November 10, 2010 at 9:52 am
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
July 25, 2011 at 3:16 pm
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply