difference between DBA_TABLES and DBA_ALL_TABLES

[joy]

I use DESCRIBE to check these two dictionary view and find that DBA_ALL_TABLES has two more columns (TABLE_TYPE_OWNER, TABLE_TYPE).

What's the other difference between these two views?

[Mr.Hanky]

TABLE_NAME COMMENTS
------------------------------ -----------------------------------
DBA_ALL_TABLES Description of all object and
relational tables in the database

TABLE_NAME COMMENTS
------------------------------ -----------------------------------
DBA_TABLES Description of all relational
tables in the database


This is from a select on dict where table_name ='blah_blah' Got it?
MH

[joy]

Thanks for also telling me how to get the info !

[dragon99]

Hi, it is an interesting topic. I did a select count from dba_tables and dba_all_tables. There are four tables are not in dba_tables. They are :
TABLE_NAME
------------------------------
KOTTD$
KOTTB$
KOTAD$
KOTMD$

What are they?
Another question is when I do select count on those two tables(or views), they are significantly slow. Why is that? Is it normal? Is it possible to make it faster?
Thanks.

Dragon