accessing Oracle data from SQL Server

I need to import a table from an Oracle database to a table in a SQ开发者_运维问答L Server 2008 Enterprise database. What is the most quick and easy solution? Could I use linked server (to link from SQL Server 2008 to Oracle) to select * from Oracle table, and insert them to SQL Server table? Appreciate if there is any ready to use documents.

BTW: since the Oracle table contains binary fields (BLOB), so export data in Oracle table to a text file then import text file into SQL Server may not feasible, correct?

thanks in advance, George

---

Here are two articles on creating a linked server

Using OLEDB Connection on a 32bit SQL Server http://www.sqlmag.com/article/sql-server/setting-up-an-oracle-linked-server49687.aspx

Using ODBC on a 64bit SQL Server http://tlingenf.spaces.live.com/blog/cns!B1B09F516B5BAEBF!216.entry

Or google "SQL Server 2008 Create Linked Server to Oracle"