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

From: gmei <gmei_at_incyte.com>
Date: Tue, 04 Feb 2003 09:14:27 -0800
Message-ID: <F001.00543643.20030204091427@fatcity.com>

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: ORACLE-L_at_fatcity.com
Cc: gmei_at_incyte.com

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.
jerome.whittle_at_scott.af.mil
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 >>>

Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit

The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.

This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster_at_fatcity.com for clarification.

------=_NextPart_000_001F_01C2CC47.05B53060--

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: gmei
  INET: gmei_at_incyte.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Feb 04 2003 - 11:14:27 CST