EXEC sp_addlinkedserver
@server = 'DBMV',
@srvproduct = 'Oracle',
@provider = 'OraOLEDB.Oracle',
@datasrc = '(DESCRIPTION=ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.0.65)(PORT = 1521))(CONNECT_DATA=(SID=dbmv)))'
GO
EXEC sp_addlinkedsrvlogin
@rmtsrvname = 'DBMV',
@useself = 'FALSE',
@rmtuser = 'leomar',
@rmtpassword = 'leomar123'
GO