select table_name,
       to_number(extractvalue(
                   dbms_xmlgen.getXMLtype ('select count(*) cnt from '||table_name),
                   '/ROWSET/ROW/CNT')) rows_in_table
from user_tables
where -- a real table
      (   tablespace_name is not null 
       or partitioned='YES' 
       or nvl(iot_type,'NOT_IOT')='IOT' )
      -- not an iot overflow
  and nvl(iot_type,'NOT_IOT') not in ('IOT_OVERFLOW','IOT_MAPPING') 
      -- not a mview log
  and (user, table_name) not in (select log_owner, log_table from user_mview_logs)
order by 1
/

SCOTT> select table_name,
  2         to_number(extractvalue(
  3                     dbms_xmlgen.getXMLtype ('select count(*) cnt from '||table_name),
  4                     '/ROWSET/ROW/CNT')) rows_in_table
  5  from user_tables
  6  where -- a real table
  7        (   tablespace_name is not null 
  8         or partitioned='YES' 
  9         or nvl(iot_type,'NOT_IOT')='IOT' )
 10        -- not an iot overflow
 11    and nvl(iot_type,'NOT_IOT') not in ('IOT_OVERFLOW','IOT_MAPPING') 
 12        -- not a mview log
 13    and (user, table_name) not in (select log_owner, log_table from user_mview_logs)
 14  order by 1
 15  /
TABLE_NAME                     ROWS_IN_TABLE
------------------------------ -------------
BONUS                                      0
DEPT                                       4
EMP                                       14
SALGRADE                                   5

SCOTT> with 
  2    data as (
  3      select table_name,
  4             to_number(extractvalue(
  5                         dbms_xmlgen.getXMLtype ('select count(*) cnt from '||table_name),
  6                         '/ROWSET/ROW/CNT')) rows_in_table
  7      from user_tables
  8      where -- a real table
  9            (   tablespace_name is not null 
 10             or partitioned='YES' 
 11             or nvl(iot_type,'NOT_IOT')='IOT' )
 12            -- not an iot overflow
 13        and nvl(iot_type,'NOT_IOT') not in ('IOT_OVERFLOW','IOT_MAPPING') 
 14            -- not a mview log
 15        and (user, table_name) not in (select log_owner, log_table from user_mview_logs)
 16    )
 17  select decode(rows_in_table, 0, 'EMPTY', 'SOME ROWS') what,
 18         count(*) nb_tables
 19  from data
 20  group by decode(rows_in_table, 0, 'EMPTY', 'SOME ROWS') 
 21  /
WHAT       NB_TABLES
--------- ----------
SOME ROWS          3
EMPTY              1

select table_name,num_rows from user_tables

SQL>
SQL> select table_name,
  2           to_number(extractvalue(
  3                       dbms_xmlgen.getXMLtype ('select count(*) cnt from '||table_name),
  4                      '/ROWSET/ROW/CNT')) rows_in_table
  5    from user_tables
  6    where -- a real table
  7          (   tablespace_name is not null
  8           or partitioned='YES'
  9           or nvl(iot_type,'NOT_IOT')='IOT' )
 10          -- not an iot overflow
 11      and nvl(iot_type,'NOT_IOT') not in ('IOT_OVERFLOW','IOT_MAPPING')
 12          -- not a mview log
 13      and (user, table_name) not in (select log_owner, log_table from user_mview_logs)
 14    order by 1
 15  /
                     dbms_xmlgen.getXMLtype ('select count(*) cnt from '||table_name),
                     *
ERROR at line 3:
ORA-19202: Error occurred in XML processing
ORA-00911: invalid character
ORA-06512: at "SYS.DBMS_XMLGEN", line 288
ORA-06512: at line 1

select table_name from user_tables 
where (   translate(table_name,' ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789_$#',' ') is not null
       or translate(substr(table_name,1,1),' ABCDEFGHIJKLMNOPQRSTUVWXYZ',' ') is not null )
  and (   tablespace_name is not null 
       or partitioned='YES' 
       or nvl(iot_type,'NOT_IOT')='IOT' )
      -- not an iot overflow
  and nvl(iot_type,'NOT_IOT') not in ('IOT_OVERFLOW','IOT_MAPPING') 
      -- not a mview log
  and (user, table_name) not in (select log_owner, log_table from user_mview_logs)
order by 1
/

select table_name,
       to_number(extractvalue(
                   dbms_xmlgen.getXMLtype ('select count(*) cnt from "'||table_name||'"'),
                   '/ROWSET/ROW/CNT')) rows_in_table
from user_tables
where -- a real table
      (   tablespace_name is not null
       or partitioned='YES'
       or nvl(iot_type,'NOT_IOT')='IOT' )
      -- not an iot overflow
  and nvl(iot_type,'NOT_IOT') not in ('IOT_OVERFLOW','IOT_MAPPING')
      -- not a mview log
  and (user, table_name) not in (select log_owner, log_table from user_mview_logs)
order by 1
/

CREATE TABLE FZEXPRD_DBA."gs" ( "hours" NUMBER(19) NOT NULL, "min" NUMBER(5) NOT NULL, "type" VARCHAR2(21 BYTE) NOT NULL, "sys" VARCHAR2(28 BYTE) NOT NULL, "day" DATE NOT NULL ) TABLESPACE TS_OTHER_TAB PCTUSED 0 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE NOPARALLEL MONITORING;

begin
DBMS_STATS.GATHER_SCHEMA_STATS( 'PIRM_OWNER'); 
end;