SQL server 2012 - Oracle Replication

Posted on 2012-09-10
Last Modified: 2012-10-17
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.
Question by:HumanScaleDev
    LVL 5

    Expert Comment

    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.

    Accepted Solution

    Modified the package in oracle to remove uodate on clause in trigger

    Author Closing Comment

    Proved to be working

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    Title # Comments Views Activity
    Add 0 to end of Number 21 58
    MySQL 11 44
    PL/SQL Two statements 6 32
    oracle query help 36 36
    How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    Via a live example, show how to take different types of Oracle backups using RMAN.
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now