查询某用户下所有表记录数

SQL> select t.owner,count(*)  from all_tables t group by t.owner;

OWNER                                                                                        COUNT(*)
------------------------------------------------------------------------------------------ ----------
MDSYS                                                                                              49
TSMSYS                                                                                              1
DMSYS                                                                                               2
OUTLN                                                                                               3
CTXSYS                                                                                             37
OLAPSYS                                                                                           126
HR                                                                                                  7
SYSTEM                                                                                            141
EXFSYS                                                                                             44
SCOTT                                                                                               4
SH                                                                                                 17

OWNER                                                                                        COUNT(*)
------------------------------------------------------------------------------------------ ----------
DBSNMP                                                                                             21
ORDSYS                                                                                              4
SYSMAN                                                                                            337
OE                                                                                                 12
PM                                                                                                  2
XDB                                                                                                11
ATYU30                                                                                             12
IX                                                                                                 15
SYS                                                                                               703
WMSYS                                                                                              40

已选择21行。