Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to migrate SQL Server image data type to Oracle 8 BLOB data type?

663858Oct 13 2008 — edited Oct 15 2008

Hi,

I have to migrate data from sql server to Oracle 10 g.

I am unable to migrate image data type from sql server to blob data type in oracle.

Iam using Oracle Heterogenous Services to migrate the data,Using Merge statement and database link.

I am getting the following error-

ERROR at line 7:
ORA-00932: inconsistent datatypes: expected BLOB got LONG BINARY

Can any one suggest me how to migrate Image datatype to BLOB???

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 12 2008

Added on Oct 13 2008

#database-and-application-migrations

1 comment

3,717 views