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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Query against linked server (Oracle)

Author  Topic 

nemohm
Yak Posting Veteran

69 Posts

Posted - 2003-06-12 : 12:12:57
Hi

I’ve created a linked server to Oracle (thanks to your help).

I can see all tables, but I’m not able to execute a query against Oracle database.

When I use:

select count (*) from [PHD].[PETER].[Event]

(or any select )
-------------
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'PHD.PETER.Event'.

PHD is my linked server
Peter is the schema
Event is the table

Case, brackets seems to have no effect.

What I’m missing?

Thank you very much!

Dobby

Shastryv
Posting Yak Master

145 Posts

Posted - 2003-06-27 : 13:39:35
Qualify the table with owner name like owner.Event

Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2003-06-30 : 03:17:57
quote:

select count (*) from [PHD].[PETER].[Event]



You are missing a dot. When you query a linked Oracle database, you need an extra dot between the linked server name and the owner name.

SELECT COUNT (*) FROM [PHD]..[PETER].[Event]

Actually, it is not an extra dot. It just means that you do not need the information that usually is in that position when referencing an Oracle database.

Also, remember that a query to oracle is case sensitive. Make sure that your table name is Event (with the 'E' capitalized). Most likely your table name is actually EVENT (all caps). The owner is also case senstive, and will most likely be all uppercase as well.

-ec

Edited by - eyechart on 06/30/2003 03:32:00
Go to Top of Page
   

- Advertisement -