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
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
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...
Click Here to Expand Forum to Full Width