PLEASE HELP ME ASAP - Refreshing materialized view at Oracle replication sites [message #75290] |
Sat, 16 November 2002 15:13 |
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
|
|
|
|
|