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

    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


    raj
    krajdba, Dec 11, 2006
    #2

  2. MohammedU New Member

    I believe you can TEXT datatype.


    Mohammed U.
    MohammedU, Dec 11, 2006
    #2

  3. dineshasanka Moderator

    dineshasanka, Dec 11, 2006
    #2

  4. krajdba New Member

    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.
    ---------------------------
    OK
    ---------------------------

    raj
    krajdba, Dec 12, 2006
    #2

  5. satya Moderator

    http://www.sqlservercentral.com/columnists/hji/oracleandsqlserverdatainteroperabilityissuespart1.asp

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
    satya, Dec 12, 2006
    #2

  6. krajdba New Member

    Thanks satya,

    thanks a lot



    raj
    krajdba, Dec 12, 2006
    #2

  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


    raj
    krajdba, Dec 13, 2006
    #2

  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)



    ---------------------------
    OK
    ---------------------------

    Please help. Very Urgent.

    raj
    krajdba, Dec 13, 2006
    #2

  9. techbabu303 New Member

    Have you tried to use "ntext" or "image" datatype which is equivalent to clob in oracle ?
    techbabu303, Dec 15, 2006
    #2

Share This Page