Home » Server Options » Replication » PLEASE HELP ME ASAP - Refreshing materialized view at Oracle replication sites
PLEASE HELP ME ASAP - Refreshing materialized view at Oracle replication sites [message #75290] Sat, 16 November 2002 15:13 Go to next message
Ikhsan Aminuddin
Messages: 1
Registered: November 2002
Junior Member
dear readers..
i'm doing my thesis right now about replicating materialized view at few sites..
and i'm so worried about problem and there was an error while i was refreshing all materialized view at all sites by executing this package:
execute DBMS_REFRESH.REFRESH ('hr_refg');
an the error messages are:
ORA-23402: refresh was aborted because of conflicts caused by deferred txns
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 794
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 851
ORA-06512: at "SYS.DBMS_IREFRESH", line 683
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1
did i miss something?!
did i make some mistake?!
if i did, please send me the answer ASAP, because I need it so bad..

Ikhsan-Jakarta
Re: PLEASE HELP ME ASAP - Refreshing materialized view at Oracle replication sites [message #75472 is a reply to message #75290] Fri, 20 February 2004 00:41 Go to previous messageGo to next message
YOGENDRA
Messages: 1
Registered: February 2004
Junior Member
use this command..

execute DBMS_SNAPSHOT.REFRESH( 'YOGI1','F');

yogendra from India
Re: PLEASE HELP ME ASAP - Refreshing materialized view at Oracle replication sites [message #171145 is a reply to message #75290] Mon, 08 May 2006 12:53 Go to previous message
heshkak
Messages: 1
Registered: May 2006
Junior Member
I found that the easiest way to deal with this issue is to:

1) Login to Oracle Enterprise Manager with the replication adminstrator user
2) Go to: Distributed->Advanced Replication->Administration
3) On the right there will be a tab called "Errors"
4) Delete or Re-run the error shown with the buttons on the bottom right.

-Hesh
Previous Topic: Stream or advance replication
Next Topic: Table Replication.
Goto Forum:
  


Current Time: Fri Jun 18 21:14:51 CDT 2021