Re: DBMS_SNAPSHOT error...

Magnus Andersen wrote:
> 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

First thought is you are on software well into desupport and you don't even have a current patchset. Patch to 8.1.7.4.

But temporarily I'd be running a query like this: SELECT object_name, object_type
FROM dba_objects
WHERE status = 'INVALID';

and reading the alert logs.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)