| No data found error [message #361563] |
Thu, 27 November 2008 00:26  |
sanei05
Messages: 104
Registered: September 2008
|
Senior Member |
|
|
hi,
In multimaster replication, I am getting the following error in the master sites.
ORA-01403: no data found
ORA-01403: no data found
But when i checked for the data, I found that the records are present. what is the cause for this and how to resolve this..
|
|
|
|
|
|
| Re: No data found error [message #361656 is a reply to message #361649] |
Thu, 27 November 2008 04:57  |
sanei05
Messages: 104
Registered: September 2008
|
Senior Member |
|
|
tried..
again i get the below error
stack trace:----------------
ORA-01430 : NO DATA FOUND
ORA-06512 : at "SYS.DBMS_DEFER_SYS_PART1",line 442
ORA-06512 : at "SYS.DBMS_SYS",line 1854
ORA-06512 : at "SYS.DBMS_DEFER_SYS", line 1900
ORA-06512 : at line 2
|
|
|
|
| Re: No data found error [message #361664 is a reply to message #361656] |
Thu, 27 November 2008 06:16 |
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
|
Senior Member |
 
|
|
Please explain me which method did you tried??
Or
Try this
SQL> spool apply_errors.sql
SQL> select 'exec dbms_defer_sys.execute_error( || deferred_tran_id ||,||
SQL> destination || )'
SQL> from deferror;
SQL> spool off
SQL> @apply_errors
SQL> commit;
PS: Pls try order by date
Babu
[Updated on: Thu, 27 November 2008 06:18] Report message to a moderator |
|
|
|
|
|
| Re: No data found error [message #362636 is a reply to message #361675] |
Wed, 03 December 2008 08:05 |
sanei05
Messages: 104
Registered: September 2008
|
Senior Member |
|
|
Hi,
In my multi master replication environment, updates done from master definition site are getting failed in only one master site,.
I re-executed the error and again failed..
how can we solve the update failure..
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
