Oracle database in enterprise manager SQL 2000

Can I access an Oracle database in enterprise manager SQL 2000? How do I proceed?

YOu will have to create a linked server in SQL Server 2000 using the appropiate provider. THen you can scroll through the metadata of oracle server. Querying the tables is not possible from the GUI. After creating a linked server you will have to use queries in the syntax of

SELECT * FROM LinkedServername.Database.Schema.ObjectName

(four part naming) to access the oracle Database.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de