help exporting data to Oracle

hi,
i'm trying to export data from Sql Server to Oracle, when i try i get
a message saying that the values in a column are too large, in sql
server the column is of type ntext length 16, in Oracle its long, is
there something i can do? if i need to change Oracle's long to
something else, what should i make it blob?
Thanks.I am not an Oracle guy, but the name 'long' sounds like a numeric datatype,
not textual. I think BLOB will be more appropriate for large text data.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"soni29" <soni29@.hotmail.com> wrote in message
news:cad7a075.0402181427.31bcffc4@.posting.google.com...
hi,
i'm trying to export data from Sql Server to Oracle, when i try i get
a message saying that the values in a column are too large, in sql
server the column is of type ntext length 16, in Oracle its long, is
there something i can do? if i need to change Oracle's long to
something else, what should i make it blob?
Thanks.sql