DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: difference between DBA_TABLES and DBA_ALL_TABLES

  1. #1
    Join Date
    Apr 2001
    Posts
    16

    Question

    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?

  2. #2
    Join Date
    Jan 2001
    Posts
    3,134
    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

  3. #3
    Join Date
    Apr 2001
    Posts
    16

    Smile

    Thanks for also telling me how to get the info !

  4. #4
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    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
  •  


Click Here to Expand Forum to Full Width