Home » Server Options » Replication » materialized view refresh with trigger - URGENT
materialized view refresh with trigger - URGENT [message #46966] Tue, 13 July 2004 08:44 Go to next message
Messages: 6
Registered: July 2004
Junior Member
i get a trigger to refresh materialized view..

my trigger

create or replace trigger t1_update_mw_trig
after update on T1 (c11, c12)
for each row
dbms_mview.refresh(para1, para2, para3...);

and now it gives me this error

Error:ORA-04092: it´s not possible COMMIT in trigger

ORA-06512: em "SYS.DBMS_SNAPSHOT", line 869
ORA-06512: em "SYS.DBMS_SNAPSHOT", line 852
ORA-06512: em "ANIID.T15_UPDATE_MW_TRIG", line 2
ORA-04088: error during the execute  trigger 'ANIID.T15_UPDATE_MW_TRIG'

my oracle is 9.0.1

and i don´t have any idea what´s the problem

this is Urgente...

Re: materialized view refresh with trigger - URGENT [message #46971 is a reply to message #46966] Tue, 13 July 2004 18:49 Go to previous message
Jai Vrat Singh
Messages: 205
Registered: September 2002
Location: Singapore
Senior Member
It it correct that you cannot commit inside a trigger, unless you make it an autonomous transaction. You error message says
ORA-04088: error during the execute trigger 'ANIID.T15_UPDATE_MW_TRIG'

This means that it is not this trigger where error originates but it is T15_UPDATE_MW_TRIG

You can see the source code of this trigger for what is happening? please query

select table_name,trigger_name from all_triggers where trigger_name like 'T%_UPDATE_MW_TRIG' to see what are the other triggers attached with this.
Previous Topic: materialized view refresh problem - URGENT
Next Topic: Materialized view - Time out available?
Goto Forum:

Current Time: Wed Dec 08 19:13:04 CST 2021