dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

Oracle Linked server - sqlserver-datamining

This is a discussion on Oracle Linked server - sqlserver-datamining ; Hi, We created a oracle linked server. And, I run the query through linked server in SQL 2005 and oracle client (Toad), the result are different. The oracle view has the following condition where timerecd.dt_d >= '11-NOV-2007' Looks like the ...


Home > Database Forum > Data Warehousing > sqlserver-datamining > Oracle Linked server

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 09-29-2008, 07:58 PM
Database Bot
  
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Oracle Linked server
Hi,

We created a oracle linked server. And, I run the query through linked
server in SQL 2005 and oracle client (Toad), the result are different.

The oracle view has the following condition

where timerecd.dt_d >= '11-NOV-2007'

Looks like the query through oracle linked server didn't honor the original
view condition and the result would return all the record with old date?

Is this the known bug?

Thank you for your help.
--
Best Regards,

Lynn
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode



All times are GMT -4. The time now is 03:40 AM.