-
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?
-
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
-
Thanks for also telling me how to get the info !
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|