Replicat Abending ora:24344- success with compilation error
938450Jul 9 2012 — edited Jul 13 2012Hi Friends
We are doing a database migration from Hp-ux oracle 10.2.0.4 to exadata machine oracle 11.2.0.3. We are using oracle goldengate 11.2.1.0.1 on both source and target. The replication was fine. On friday evening 7/6/2012 the replicat got abended when it was trying to execute a DDL[Error code [24344], ORA-24344: success with compilation error SQL create or replace PACKAGE BODY xxxxxxx."xxxx".
The error is "Body 652 5 PL/SQL: ORA-00933: SQL command not properly ended".
The package body got recreated fine on source database with no compliation error but when the replicat is trying to execute the same on target it is able to but with compilation error
Thanks