SQL Server Performance

Using DTS between Oracle and SQL Server databases.

Discussion in 'SQL Server DTS-Related Questions' started by krajdba, Dec 11, 2006.

  1. krajdba New Member


    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

  2. MohammedU New Member

    I believe you can TEXT datatype.

    Mohammed U.
  3. dineshasanka Moderator

  4. krajdba New Member


    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.

  5. satya Moderator


    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.
  6. krajdba New Member

    Thanks satya,

    thanks a lot

  7. krajdba New Member

    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

  8. krajdba New Member

    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.

  9. techbabu303 New Member

    Have you tried to use "ntext" or "image" datatype which is equivalent to clob in oracle ?

Share This Page