Topic: 请教高手：How to use Distributed Queries at SQL Server to get Data from "linked" Oracle(Linedserver--one funcation provided at SQL Server": @枫下论坛 The Rolia Forum

工作学习 / IT技术讨论 / 请教高手：How to use Distributed Queries at SQL Server to get Data from "linked" Oracle(Linedserver--one funcation provided at SQL Server": -guest:Anxiety; 2001-5-10 {355} (#66469@0)
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!!!