DBMS_SNAPSHOT error...

From: Magnus Andersen <mag.andersen_at_gmail.com>
Date: 27 Jan 2006 03:49:54 -0800
Message-ID: <1138362594.404600.317240@o13g2000cwo.googlegroups.com>

HI All,

I'm suddenly receiving an ORA-04092 error when trying to do a complete refresh of a snapshot. I haven't had any changes to the database.

Database version: 8.1.7.2
OS: HP-UX 11.0

Error:
SQL> exec dbms_snapshot.refresh('ITM_VNDR_UOM_PR','C');

begin dbms_snapshot.refresh('ITM_VNDR_UOM_PR','C'); end;

ORA-04092: cannot COMMIT in a trigger
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 658
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 641
ORA-06512: at line 1

Any thoughts?

Thanks,
Magnus Received on Fri Jan 27 2006 - 05:49:54 CST