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 tell me how to add Oracle database 18c mappings in SQL Server 2008 R2?
Many thanks in advance!