select count(table_name),sum(num_rows) from all_tables where owner not in ('SYS' ,'SYSTEM' ,'SCOTT' ,'OUTLN' ,'MGMT_VIEW' ,'FLOWS_FILES' ,'MDSYS' ,'ORDSYS' ,'EXFSYS' ,'DBSNMP' ,'WMSYS' ,'APPQOSSYS' ,'APEX_030200' ,'OWBSYS_AUDIT' ,'ORDDATA' ,'CTXSYS' ,'ANONYMOUS' ,'SYSMAN' ,'XDB' ,'ORDPLUGINS' ,'OWBSYS' ,'SI_INFORMTN_SCHEMA' ,'OLAPSYS' ,'ORACLE_OCM' ,'XS$NULL' ,'MDDATA' ,'DIP' ,'APEX_PUBLIC_USER' ,'SPATIAL_CSW_ADMIN_USR' ,'SPATIAL_WFS_ADMIN_USR');
统计数据库中业务表的数目和记录总数
最新推荐文章于 2024-04-28 16:20:18 发布