请教高手:How to use Distributed Queries at SQL Server to get Data from "linked" Oracle(Linedserver--one funcation provided at SQL Server":

guest (Anxiety)
We can use mysqlserver1.northwind.dbo.region to deal with the region table at northwind database of the SQL Server, BUT I DON'T KNOW how to express the table at the linked Oracle database: it's should be Servername.catalogue.schema.object
But what is the catalogue and schema (for example the table EMP at the default database) ?
Thanks in advance!!!
(#66469@0)
2001-5-10 -05:00

回到话题: 请教高手:How to use Distributed Queries at SQL Server to get Data from "linked" Oracle(Linedserver--one funcation provided at SQL Server":

回到论坛: HOME枫下论坛枫下论坛主坛工作学习IT技术讨论

URL:   
http://www.rolia.net/zh/post.php?f=0&p=66469