EXEC master.dbo.sp_MSset_oledb_prop N'OraOLEDB.Oracle', N'AllowInProcess', 1; EXEC sp_addlinkedserver @server = 'XE', @srvproduct = 'Oracle', @provider = 'OraOLEDB.Oracle', @datasrc = '//localhost/orcl'; Exec sp_serveroption 'XE' , 'rpc' , TRUE; Exec sp_serveroption 'XE' , 'data access' , TRUE; Exec sp_serveroption 'XE' , 'rpc out' , TRUE; EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'XE', @useself = N'False', @rmtuser = N'jjs', @rmtpassword = N'jjs'; SELECT * FROM OPENQUERY(XE,'SELECT * FROM test_Tbl where p2 < 1000 and reg_dt >=' || '2012-10-01'); select * from [XE]..JJs.TEST_TBL;