SQL Server Performance

Replicating to oracle Subscriber

Discussion in 'SQL Server 2008 Replication' started by hrishikesh_nk, Feb 26, 2011.

  1. hrishikesh_nk New Member

    Hii,
    I am facing a issue when replicating a table from SQL server 2008 to Oracle Server 11G.This is the first time i am setting a replication to a non-SQL server subscriber.I am receiving an error"ORA-00932: inconsistent datatypes: expected INTERVAL DAY TO SECOND got NUMBER (Source: MSSQL_REPL_ORACLE, Error number: 932)"
    I read a lot about this error on google and support.microsoft.com but couldnt solve the problem.
    I dont have any connectivity issues.Please suggest some workaround or possible causes for this error.
    Also will like to know about MSREPL7 table which got created in oracle.
  2. ghemant Moderator

    Hi,
    Did you happened to check and map the data type before you create oracle subscriber? Did you try sp_MSrepl_CreateDatatypeMappings ?

Share This Page