Solved

Oracle linked server error

Posted on 2010-09-01
6
299 Views
Last Modified: 2012-05-10
Hello All,

I am trying to query an Oracle database from a linked 2005 SQL Server. I am pretty sure the error has something to do with the table name being DOCUMENT. I can query all other tables in the server except this one one, I even put the table name in brackets and get the same error(s). Code
0
Comment
Question by:Lobregon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
6 Comments
 
LVL 2

Expert Comment

by:MaxterJF
ID: 33582105
It's true that DOCUMENT is a reserved word in Oracle.  If you call "SELECT * FROM "EMRTST2".."ML"."DOCUMENT" that should be working (it's true that it's Pervasive way to call objects but oh well.... why not to try it?)
0
 
LVL 1

Author Comment

by:Lobregon
ID: 33582147
No that didn't work... I can query it just fine within an Oracle SQL Developer Screen.
PrtScr-capture-15.jpg
0
 
LVL 13

Expert Comment

by:riazpk
ID: 33584174
If you have SQL Server Management Studio, just check whether you can see the table when you choose the following options:
Linked Servers -> EMRTST2 -> Catalogs -> default -> tables
0
 
LVL 1

Author Comment

by:Lobregon
ID: 33588930
Yeah I can see it... Just cant Query it....
PrtScr-capture-16.jpg
0
 
LVL 1

Accepted Solution

by:
Lobregon earned 0 total points
ID: 33589121
I ended up making of a view of the table in Oracle and querying that view via SQL Server... I know just a band-aid but it works.
0

Featured Post

Automating Terraform w Jenkins & AWS CodeCommit

How to configure Jenkins and CodeCommit to allow users to easily create and destroy infrastructure using Terraform code.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question