RE: why these tables can not be seen from user_segments?

[gmei]

They don't seem to be views, they are tables
 
SQL> select view_name from user_views  where view_name like 'DR$%';
 
no rows selected
 
SQL> 

-----Original Message-----
Sent: Tuesday, February 04, 2003 11:53 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]



Hi, 

I found this out the hard way to: dba_tables, all_tables, and user_tables
also include views. Of course, views don't have segments.....

Jerry Whittle 
ASIFICS DBA 
NCI Information Systems Inc. 
[EMAIL PROTECTED] 
618-622-4145 

        -----Original Message----- 

        Hi: 

        Oracle 8173 on Sun Box. 

        SQL> select count(*) from user_tables; 

          COUNT(*) 
---------- 
       326 

        SQL> select count(*) from user_segments where segment_type='TABLE'; 

          COUNT(*) 
---------- 
       318 

        <<<  stuff cut >>> 

<<winmail.dat>>