Exporting from SqlServer to Oracle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Exporting from SqlServer to Oracle

  1. #1
    Join Date
    Jan 2002
    I'm exporting some tables from SQL Server to Oracle but I can't export tables which contain more than a Long type field.
    Can somebody tell me how can I export the whole table?
    I thought about exporting the table without that fields,and in Oracle,I convert the long field to CLOB or BLOB,because the fields are just images,and I think I can handle them with CLOB or BLOB type too.And then,i export the other LONG field from SQL Server...
    But another question is if CLOB or BLOB fields can be handled as LONG type refering to programming later and that kind of things...I don't know very much about that kind of fields...
    Help,please.Thanks in advance

  2. #2
    Join Date
    Dec 2000
    Brazil / São Paulo


    What Oracle and SQL Server version ?
    Márcio de Souza Almeida
    DBA Oracle / SQLServer / PostgreSQL
    Rua Cupa, 139 Apto 85 A
    Penha - São Paulo - SP
    03640-000 - Brasil

  3. #3
    Join Date
    Jan 2002
    from SQL Server 7.0 to Oracle 8.1.7 .
    But I export directly from SQL Server.I don't have any tool with my Oracle to import data...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width