server to oracle9i

What is the procedure to set up a linked server to Oracle9i from sql 2000.
Thanks
See sp_addlinkedserver
http://msdn.microsoft.com/library/de..._adda_8gqa.asp
C. Use the Microsoft OLE DB Provider for Oracle
This example creates a linked server named LONDON Mktg that uses the
Microsoft OLE DB Provider for Oracle and assumes that the SQL*Net alias for
the Oracle database is MyServer.
USE master
GO
-- To use named parameters:
EXEC sp_addlinkedserver
@.server = 'LONDON Mktg',
@.srvproduct = 'Oracle',
@.provider = 'MSDAORA',
@.datasrc = 'MyServer'
GO
-- OR to use no named parameters:
USE master
GO
EXEC sp_addlinkedserver
'LONDON Mktg',
'Oracle',
'MSDAORA',
'MyServer'
GO
And read http://support.microsoft.com/?id=280106 How to set up and
troubleshoot a linked server to Oracle in SQL ServerGertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2005 All rights reserved.
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:CEDEF37A-F2F4-4D0C-8318-286CF728FD20@.microsoft.com...
> What is the procedure to set up a linked server to Oracle9i from sql 2000.
> Thanks