Thanks for the reply

There is no change in datatypes for both platforms.

We have raised the issue with Oracle and they confirm that its bug

Please find bug details...

Thanks for the update.:-)

We were using below query which was working fine .

UPDATE A

SET A.IsPushToOracle=1, A.PUSHED_BY=13362, A.PUSHED_DATE=GETDATE()

--SELECT *

from <sql table > A

inner join openquery (<linked serve query >')B

ON CONVERT(VARCHAR,B.ATTRIBUTE6)...

you can use following command to reduce log size of database .

use <database_name>

dbcc shrinkfile(2,10)

If user is member of sysadmin fixed server role they can perform any activity in the server.

There is no meaning of mapping user explicitly to...

Dear Sir,

when i use your query i found same culprit which was you found.

Please tell us how to reduce that culprit.

Thanks.