使用user_tables获取权限范围内所有表及数据量
SELECT table_name, TO_NUMBER(EXTRACTVALUE(xmltype(
DBMS_XMLGEN.getxml('SELECT COUNT(*) c FROM '||table_name))
, '/ROWSET/ROW/C')) AS row_count
FROM user_tables order by table_name;
使用user_tables获取权限范围内所有表及数据量
SELECT table_name, TO_NUMBER(EXTRACTVALUE(xmltype(
DBMS_XMLGEN.getxml('SELECT COUNT(*) c FROM '||table_name))
, '/ROWSET/ROW/C')) AS row_count
FROM user_tables order by table_name;