On May 4, 11:48 am, siva.thirumai..._at_gmail.com wrote:
> Hi,
>
> I am facing issues with the MultiMaster Replication implemented on the
> Oracle 8i Databases. I am getting the following error while
> reexecuting the errors generated by the deferred transactions through
> OEM. Please let me know if there is any alternate way to handle the
> errors occured during the execution of the deferred transactions which
> are executed automatically.
>
> Statement:-------------------------------
> Begin
> DBMS_DEFER_SYS.EXECUTE_ERROR(...
> ...);
> End
>
> Stack Trace:-----------------------------
>
> ORA-01403: no data found
> ORA-01403: no data found
> ORA-06512: at"SYS.DBMS_DEFER_SYS_PART1", line 430
> ORA-06512: at"SYS.DBMS_DEFER_SYS", line 1632
> ORA-06512: at"SYS.DBMS_DEFER_SYS", line 1678
> ORA-06512: at line 2
>
> Please let me know if there is any other method to resolve this issue
> in lesser time.
>
> Thanks in advance!!!
Take a look at the DBMS_RECTIFIER_DIFF package (Replication Management
API Reference doc). It has two procedures which would help you solve
the issue.
Valentin
Received on Fri May 04 2007 - 14:59:06 CDT
