dbvrep.EMPTY_BLOB does not exist

Hello,

We are trying to do test dbvisit replication from oracle to mysql.

And when we run the replication on a table with the following error:

RETRY:FUNCTION dbvrep.EMPTY_BLOB does not exist

Can you please tell us what to do to resolve this issue?

Hatem

BENNOUR June 23, 2013 08:17

Please sign in to leave a comment.

Hello Hatem,

The replication of LOBs, BLOBs and CLOBs from Oracle to MySql is not currently supported (or for any non-Oracle targets):

https://dbvisit.atlassian.net/wiki/display/ugdr/Supported+and+Unsupported+Datatypes

Therefore what you will need to do is to exclude the column(s) in question from the replication. For more detail on this please see HERE.

Mike Donovan July 15, 2013 00:29 0 votes