SQL Server - Heterogeneous Replication RRS feed

  • Question

  • Hi,

    We currently have the below replication setup in SQL Server & it is working fine.

    SQL Server 2008 R2 is both “Publisher” and “Distributor” too.

    Oracle database 11g release 1 is “Subscriber”.

    Now, when we try to make Oracle database 18c as “Subscriber”, SQL Server throws the below error message:

    ORA-00932: inconsistent datatypes: expected FILE got BINARY (Source: <publisher name>, Error number: 932)

    Get help: http://help/932

    I assume we are getting this error because, SQL Server doesn’t have the datatype between Oracle18c & SQL Server.

    I executed the below command... and I only see Oracle database mapping till 11g.

    exec sp_helpdatatypemap

    @source_dbms = N'MSSQLSERVER',

    @destination_dbms = N'ORACLE'

    Can someone help me how to add Oracle database 18c mappings in SQL Server 2008 R2?

    Many thanks in advance!

    Friday, May 17, 2019 12:20 PM


All replies