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 |
|
nemohm
Yak Posting Veteran
69 Posts |
 Posted - 2003-06-12 : 12:12:57
|
| HiI’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 1Invalid object name 'PHD.PETER.Event'.PHD is my linked serverPeter is the schemaEvent is the tableCase, 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 |
 |
|
|
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.-ecEdited by - eyechart on 06/30/2003 03:32:00 |
|
|
|
|
|
|
Query against linked server (Oracle)