Selecting LONG datatype from Oracle connector

mohdtausifsh · Post by **mohdtausifsh** » Fri Jan 27, 2012 11:09 am

HI All
We are in process of migrating data from Oracle to 9i to MS Sql 2005.
There are some oracle tables containing long datatype ,when iam trying to select the table containing long column data is not displayed.I would like to know if there is any option which i need to select in oracle connector to be able to view the data and load the data in MS Sql table.

Regards
Mohammed

ray.wurlod · Post by **ray.wurlod** » Fri Jan 27, 2012 3:32 pm

Do you really need to view the data? Would it be sufficient to move the data from Oracle to SQL Server?

mohdtausifsh · Post by **mohdtausifsh** » Wed Feb 15, 2012 10:06 am

When i try to load the data only NULL's are getting loaded.

chulett · Post by **chulett** » Wed Feb 15, 2012 10:15 am

The LONG datatype has never been supported. They are painful to work with in SQL, never mind an ETL tool.