Trigger with V$MYSTAT producing "Table or view does not exist"
514727May 24 2006 — edited May 24 2006Greetings!
Using Oracle 9.2.0.1.0
From OEM, my table INSTRUMENT has trigger TEST01 that fires after column update. My trigger body is:
-------------------
declare
v_curr_sid number;
begin
select SID into v_curr_sid from V$MYSTAT where rownum=1;
end;
-------------------
When I try to compile the trigger I get error "Line # = 4 Column # = 35 Error Text = PL/SQL: ORA-00942: table or view does not exist", indicating it can't find V$MYSTAT. I've tried changing to SYS.V$MYSTAT and V_$MYSTAT but same problem.
Any thoughts on why? I have many many triggers that have the same problem, so I'm hoping that solving this one will solve all of them.
Many thanks!!