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
    Posts
    152
    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
    Location
    Brazil / São Paulo
    Posts
    97

    Question

    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
    http://www.directory.com.br

  3. #3
    Join Date
    Jan 2002
    Posts
    152
    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