May 14, 2018 at 2:58 am
Hi,
I've setup replication between SQL Server 2K14(Publisher) and Oracle 12c(Subscriber). During Initial snapshot load, I'm getting following error at Distribute to Subscriber history logs.
ORA-00932: inconsistent datatypes: expected FILE got BINARY (Source: MSSQL_REPL_ORACLE, Error number: 932).
I also followed guideline given in the forum:
and executed below two procedures:
xec sys.sp_MSrepl_ORAdatatypes 'Oracle', '12'
exec sys.sp_MSrepl_ORA_MSSQL_datatypemappings @source_dbms = N'ORACLE', @source_version = '12', @destination_dbms = N'MSSQLServer'
exec sys.sp_MSrepl_ORAdatatypes 'Oracle', '12'
exec sys.sp_MSrepl_MSSQL_ORA_datatypemappings @source_dbms = N'MSSQLSERVER', @destination_dbms = N'ORACLE', @destination_version = '12'
recreated publisher and subscriber, but dont kno where I'm making mistake.
How I can verify that about executed procedure created datatype mapping for Oracle 12c.
Your help will be highly appreciated in resolving this issue.
Regards,
DK.
May 15, 2018 at 5:18 am
Anybody have idea of this?
May 15, 2018 at 5:00 pm
danish.vue - Tuesday, May 15, 2018 5:18 AMAnybody have idea of this?
The mappings would end up in these tables in msdb:
MSdbms_datatype, MSdbms_datatype_mapping (and the dbms ids are in MSdbms)
Sue
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply