This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 请教高手：How to use Distributed Queries at SQL Server to get Data from "linked" Oracle(Linedserver--one funcation provided at SQL Server":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!!!
-guest:Anxiety;
2001-5-10
{355}
(#66469@0)
-
use objectname@linkname
-decathlete(Ê®Ï&i);
2001-5-21
(#76857@0)