Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-07 : 10:58:59
|
Ganeshkumar writes "I had linked a oracle server successfuly in SQL Server through Enterprise Manager and given the name 'FIR'. I'm able to see the table names of the connected Oracle database in Enterprise Manager.
Now i need to write a query in QueryAnalyzer which goes like this ' Select * from FIR.catalog.schema.tablename'. I'm not able to understand what is catalog and schema in this four part name.
I'm able to execute the query if the linked server is another SQL server where the four part name goes like this 'FIR.Northwind.dbo.employees' whereas if the linked server is a oracle database, i'm not able to substitute the four part name correctly.
Please help me
" |
|
|
|
|
|
Executing SQL Query of a linked Server