Re: public synonym v$session_event

Mike.Bhaumik_at_Den.Galileo.com wrote:

> Hi
> Here is a situation which surprises me ...
>
> The public synonym v$session_event is for sys.v_$session_event Looking at
> DBA_SYNONYMS)
>
> which is a view owned by sys. ( Looking at DBA_OBJECTS )
> If U look at the definition of this view it selects
> from v$session_event. ( Looking at DBA_VIEWS )
>
> How do U explain it ? I carried the queries in Oracle 7.3.2 and on AIX 4.1
>
> Thanks in anticipation and warm regards
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

No, in my Oracle 8.05 for Linux, the public synonym is linked to SYS.V_$SESSION_EVENT ( a Table owned by SYS !!)

John K. Received on Mon Feb 08 1999 - 10:58:29 CST