Using DTS between Oracle and SQL Server databases. | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Using DTS between Oracle and SQL Server databases.

Hi I am using DTS Import for transfering the SQL Server data to Oracle. I am unable to transfer the table for CLOB datatype of Oracle into SQL Server. Could you please help me and let me know what datatype I should use to have in SQL Server to that of CLOB of Oracle. VERY VERY Urgent Please
I believe you can TEXT datatype.
Mohammed U.
yes it is text —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at

HI I am getting following error when I am trying to import CLOB datatype column table from Oracle to SQL Server.In SQL Server I am using TEXT as suggested by you still I am getting the error.Please let me know how to fix this….. —————————
DTS Import/Export Wizard Error
Error Source: Microsoft OLE DB Provider for Oracle Error Description: Unspecified error
Oracle error occurred, but error message could not be retrieved from Oracle.
Data type is not supported. Context: Error calling OpenRowset on the provider.
————————— raj Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.
Thanks satya, thanks a lot raj
Hi Satya sorry, the problem is not solved. I created a view on the table having clob datatype, for a table which was actually empty. that’s why the tranasfer was good. But when I tried on a table with data it failed. please help very very urgent
Hi Gurus I am getting this Error when I tried to use TO_CHAR….. —————————
Copy Data from Results to Results Step
Error at Source for Row number 6853. Errors encountered so far in this task: 1. ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4708, maximum: 4000) —————————
————————— Please help. Very Urgent. raj
Have you tried to use "ntext" or "image" datatype which is equivalent to clob in oracle ?