December 30, 2008 at 9:28 am
Hi ..
i need to import a table from oracle to sql server...
The problem here is i have one of the column dataype as CLOB in oracle ..so what should i do to import that into sql server...should i change it or what is the alteernative to do that ...
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
December 30, 2008 at 10:12 am
It would depend what is contained within the CLOB.
The direct equivalent in SQL is a binary data type, but if the information in the field is pure text then it would be better to store this data as a varchar(max).
Or even better would be to use SQL 2008 and convert these into the FILESTREAM data type.
December 30, 2008 at 10:19 am
Thanks Steveb...
But the problem here is when i am selecting the tale in the source it doesnt allow me ...
for example
select * from #temp1 then it doesnt allow me in the source as it has clob collumn in it...
when i write
select col,col2,col3 from #temp1 then it allows as i have not included the col4 which has clob datatype in that table in oracle...so is there any way to do this....which can even import clob datatype in to SQL server
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
December 30, 2008 at 10:27 am
I am assuming that you are using the microsoft ORACLE ODBC driver?
If this is the case then this driver does not have the ability to handle LOBs.
You would better off using the .NET Framework Data Provider for Oracle as this provides support for LOBs
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply