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