I am using dbLinks to fetch data from SQL Server 2008 to Oracle (10g)database. When I fire the command : select * from "test_table"@dbLink

Oracle throws error : select * from "test_table"@dbLink Query Execution started at Thu Mar 08 17:57:50 IST 2012 ORA-28500: connection from ORACLE to a non-Oracle system returned this message: ORA-02063: preceding line from DBLINK

On further analysis I realized this happens only for tables which have TEXTIMAGE_ON [Primary] (Specifying that text, ntext, and image columns are stored on PRIMARY filegroup)

Then I went over the create command for this table which is CREATE TABLE [dbo].[test_table]( [ADJ_ID] [numeric](19, 6) NULL, [ADJ_TYPE] [numeric](19, 6) NULL, [PK_HASH] [nvarchar](255) NULL, [WH_HASH] [nvarchar](255) NULL, [ADJ_REVISION] [numeric](19, 6) NULL, [LAST_MODIFIED_BY] [nvarchar](255) NULL, [LAST_MODIFIED_DATE] [datetime] NULL, [COMMENTFIELD] [nvarchar](2000) NULL, [DATA] [image] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] The same error is not thrown for tables which do not have filegroup specified as PRIMARY or if I have the same table without clause TEXTIMAGE_ON [PRIMARY]

Can any one suggest a solution to overcome this error?

Thanks