Monday, 24 March 2014

count tables for each user in oracle database

sql query to count no of tables owned by each user in oracle database


SELECT COUNT(*), owner  FROM ALL_TABLES group by owner;


SQL> SELECT COUNT(*), owner  FROM ALL_TABLES group by owner;
  COUNT(*) OWNER
---------- ------------------------------
        39 WIN
        39 REDON
      121 PANK
    3456 ANA
        32 MONK
        72 PAT
        93 GREF
    3456 CHIN
        10 KILM
        20 BLOG
      155 SYSTEM
   
11 rows selected.
 

No comments:

Post a Comment