PS. Am confused.

Version :
Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
PL/SQL Release 9.2.0.3.0 - Production
CORE 9.2.0.3.0 Production
TNS for 32-bit Windows: Version 9.2.0.3.0 - Production
NLSRTL Version 9.2.0.3.0 - Production

Code:
SQL> conn sys as sysdba
Enter password: 
Connected.
SQL> grant dba, resource, connect to abhay;

Grant succeeded.

SQL> conn abhay
Enter password: *****
Connected.
SQL> create trigger test_v_session after alter on schema
  2  begin
  3  select * from v$session;
  4  end;
  5  .
SQL> ed
Wrote file afiedt.buf

  1  create or replace trigger test_v_session after alter on schema
  2  begin
  3  select * from v$session; -- Oracle says Table/View does not exist
  4* end;
SQL> /

Warning: Trigger created with compilation errors.

SQL> show errors
Errors for TRIGGER TEST_V_SESSION:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2/1      PL/SQL: SQL Statement ignored
2/15     PL/SQL: ORA-00942: table or view does not exist


SQL> select * from v$session; -- Ahh now oracle feels table/view is there.

SADDR                     SID              SERIAL#               AUDSID PADDR                   USER# USERNAME          
-------- -------------------- -------------------- -------------------- -------- -------------------- -------------
7ADB3708                    1                    1                    0 7AD90C3C                    0                   
7ADB4020                    2                    1                    0 7AD90F90                    0                   
7ADB4938                    3                    1                    0 7AD912E4                    0                   
7ADB5250                    4                    1                    0 7AD91638                    0                   
7ADB5B68                    5                    1                    0 7AD9198C                    0                   
7ADB6480                    6                    1                    0 7AD91CE0                    0                   
7ADB6D98                    7                 1176                  521 7AD92034                   25 ABHAY             
7ADB76B0                    8                  319                  518 7AD926DC                   18 SCOTT             
7ADB88E0                   10                  355                  519 7AD92388                   18 SCOTT             

9 rows selected.

-- We upgraded our ACP DB to 9i today and here oracle behaves like the senario as above ( Above test case is on my local DB 9i-> simulated the problem of a DB event trigger in ACP )

-- I dont understand Oracle now a days.
Some times i get feeling, Oracle is becoming like MS SQL Server.


Any thoughts or is it bug on 9i?

Thanks
Abhay.