Re: v$_ vs v_$ ?

From: Stan <stan0074_at_yahoo.com>
Date: Wed, 01 May 2002 06:54:42 GMT
Message-ID: <3CCF9223.2070109@yahoo.com>

I think your getting confused here. v$_lock is a synonym for sys.v_$_lock view and v$lock is a synonym for v_$lock view. Their source views are totally different and hence the difference.

so as daniel said, v_$ -- > view of x$tables and v$_ -- > synonym.

hth,
-Stan

Fan Ruo Xin wrote:

> 
> Daniel Morgan wrote:
> 
> 

>>Fan Ruo Xin wrote:
>>
>>
>>>Hi,
>>>What's the difference between v$_.. and v_$... ?
>>>Thanks for any help!
>>>Rosaline
>>>
>>One is a synonym and one is the actual object.
>>
>>v$_ = synonym
>>v_$ = view
>>
>>

> 
> Then why there is a little difference between v$_lock and v_$lock?
> Thank you, Daniel!
> 
> 

>>you could find this out by looking at object_type in all_objects.
>>
>>Daniel Morgan
>>

> Received on Wed May 01 2002 - 01:54:42 CDT