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

Tue, 04 Feb 2003 10:54:07 -0800

Title: RE: why these tables can not be seen from user_segments?
Wrong,  dba_tables, all_tables, and user_tables do not include views.
Views listed in dba_views, ...
ex.:

SQLWKS> select table_name from dba_tables where table_name like 'PRCPV%';

TABLE_NAME

------------------------------

0 rows selected.

SQLWKS> select view_name from dba_views where view_name like 'PRCPV%';

VIEW_NAME

------------------------------

PRCPV_CHART_MENU_INFO

PRCPV_LANGUAGE

PRCPV_MENU_INFO

PRCPV_MESSAGE_TEXT

PRCPV_RELATIONSHIP_LAYOUT

PRCPV_REPORT_INFO

PRCPV_REPORT_MENU_INFO

7 rows selected.

 
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
 
 
 
----- Original Message -----
Sent: Tuesday, February 04, 2003 11:54 AM
Subject: RE: why these tables can not be seen from user_segments?

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-----
    From:   gmei [SMTP:[EMAIL PROTECTED]]

    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 >>>



Reply via email to