Home » Server Options » Replication » materialized view refresh problem - URGENT
materialized view refresh problem - URGENT [message #75521] Tue, 13 July 2004 04:15
marcela
Messages: 6
Registered: July 2004
Junior Member
i have created a materialized view on a on a table , but i have a problem to refresh these automatic with trigger.

i get the oracle8
my trigger
create or replace trigger t1_update_mw_trig
after update on T1 (c11, c12)
for each row
begin
dbms_mview.refresh(para1, para2, para3...);
end;

my errors
ORA-04092: isn´t possible COMMIT in trigger
ORA-06512: em "SYS.DBMS_SNAPSHOT", line 869
ORA-06512: em "SYS.DBMS_SNAPSHOT", line 852
ORA-06512: em "ANIID.T1_UPDATE_MW_TRIG", line 2
ORA-04088: error during the execute trigger 'ANIID.T1_UPDATE_MW_TRIG'

and a fill months ago this trigger function perfectly...
Previous Topic: materialized view on demand refresh problem-URGENT
Next Topic: materialized view refresh with trigger - URGENT
Goto Forum:
  


Current Time: Sun Dec 22 22:11:38 CST 2024