Ugh, I'm not really sure that you want to do this. Try downloading the freeware version of Quest's TOAD for Oracle. That being said, if you really insist:
1. Install the Oracle client on your Windows XP box. Choose the client install.
2. Configure your SQL Net settings for the Oracle connection.
3. Using either Enterprise Manager or Query Analyzer (spaddlinkedserver). Add the Oracle instance to your SQL Server. The server instance on your PC must be up and running. Specific settings for an Oracle server can be found in BOL or Google.
4. Query the linked server by using OPENQUERY or OPENROWSET.
I AM NOT recommending this. The client interface for Oracle as a SQL worksheet which you can use and which is adequate for most things. The freeware version of TOAD (already mentioned) is equally capable (and in some respects superior to QA).
Originally Posted by BeijingPinkGirl
Have you hugged your backup today?