March 18, 2010 at 1:46 am
select query from a Oracle catalog view using Oracle Linked Server in SQL Server 2008 giving wrong results(old results) but when i query from the view directly from the DB gives correct results. This View had been changed recently.....Changes have not been reflected. Please Advise
March 18, 2010 at 1:53 am
In Sql Server 2008
When I run below query:
SELECT COUNT(*)
FROM [COMPASSPROD]..[COMPASS].[VW_CTP_SS_GRP_FUND_DATA]
it gives 200 records which is incorrect.
When I run Same query in Oracle DB
SELECT COUNT(*) from [COMPASS].[VW_CTP_SS_GRP_FUND_DATA]
it gives me 400 records which is correct.
This view was changed recently....
March 21, 2010 at 4:24 pm
Two troubleshooting suggestions...
1- What happens if you run view's underlying query from SQL Server?
2- Would you mind in showing the result of "select instance_name from v$instance;" from both the Oracle box and from SQL Server?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply