-
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
http://www.directory.com.br
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|