Am confused....thinking of going back to MS SQL Server.
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.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"