DBA_OBJECTS

From: Bunyamin K. Karadeniz <bunyamink_at_havelsan.com.tr>
Date: Mon, 04 Jun 2001 01:23:31 -0700
Message-ID: <F001.00319DFE.20010604010753@fatcity.com>

I want to select locked_objects in a
view.
I run
CREATE OR REPLACE VIEW V_BUN_LOCKED_OBJECTS AS  SELECT sn.username, m.sid,
m.type,    DECODE(m.lmode, 0,

'None'                  

, 1,

'Null'                  


, 2, 'Row 

Share'                  

, 3, 'Row

Excl.'                  

, 4,

'Share'                  

, 5, 'S/Row

Excl.'                  

, 6,

'Exclusive'                  

, lmode, ltrim(to_char(lmode,'990'))) lmode,   
DECODE(m.request, 0,

'None'                  

, 1,

'Null'                  


, 2, 'Row 

Share'                  

, 3, 'Row

Excl.'                  

, 4,

'Share'                  

, 5, 'S/Row

Excl.'                  

, 6,

'Exclusive'                  

, request, ltrim(to_char(request,'990')))
request,         
obj1.object_name objname, obj2.object_name objname FROM v$session sn, V$lock m, dba_objects obj1, dba_objects obj2 WHERE sn.sid = m.sid AND m.id1 = obj1.object_id (+) AND m.id2 = obj2.object_id (+)   AND lmode != 4 ;
 
 
and  gives error or ora-942. Can not find dba_objects .
But with the same user I can query dba_objects table since my user has dba privilege.
The inside of view runs perfectly.
Why can it be?? Received on Mon Jun 04 2001 - 03:23:31 CDT