EXEC master.dbo.sp_addlinkedserver @server = N'服务器', @srvproduct=N'Oracle11g', @provider=N'OraOLEDB.Oracle', @datasrc=N'Oracle'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'服务器',@useself=N'False',@locallogin=NULL,@rmtuser=N'账号',@rmtpassword='密码'