Skip to Content
0

How to handle BLOB datatype while loading from Oracle to SQL SERVER

May 03, 2017 at 09:31 AM

118

avatar image

Hello Experts,

My scenario is...

Source: Oracle11g

Target: Sql Server

I have a performance hit While loading from oracle to Sql server with column which contains BLOB.Its changing the rows per commit to 1 by default.

Is there any work around for increasing the performance.

Thanks,

Srinivas.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Dirk Venken
May 05, 2017 at 12:54 PM
0

No. Most databases apply record-level commit when dealing with blob data.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Dirk,

Thanks for you clarification.

0