• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 707
  • Last Modified:

SQL server 2012 - Oracle Replication

SQL replication from Oracle database in SQL 2012 64 bit server gives errors  - ora 04086 - Trigger description too long
ORA 25006  - Cannot specify this column in update of caluse errors
The same tables had been replicated without issues in sql 2005 - 32 bit version
Anybody experienced this and any workarounds, please share.
0
HumanScaleDev
Asked:
HumanScaleDev
  • 2
1 Solution
 
AnandCommented:
not experienced the exact situation . but couple of ideas to share.

create a simple table and try to replicate. works well means, problem is with specific column or data type. could be some bug and u may get some patch for that.
0
 
HumanScaleDevAuthor Commented:
Modified the package in oracle to remove uodate on clause in trigger
0
 
HumanScaleDevAuthor Commented:
Proved to be working
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now