I have a table in Sql Server 2000 with a text datatype.
It is used to hold body text for physician dictation. I
need to DTS this table to an Oracle database. Everything
works fine except that the Text datatype field in Sql
Server is created as a Long datatype field in Oracle. Is
there a way to specify that the Text datatype field in Sql
Server be created in Oracle as a BLOB field?

Thanks,

Robert