Oracle查询表数量

1.查询当前用户表数量

SELECT
  t.table_name,
  t.num_rows
FROM
  user_tables t
ORDER BY
  t.num_rows DESC;

2.查询所有用户表数量

SELECT t.table_name,t.num_rows FROM all_tables t ORDER BY t.num_rows DESC；

3.查询指定用户表数据量

SELECT
  t.OWNER,
  t.table_name,
  t.num_rows,
  c.comments
FROM
  all_tables t
  LEFT JOIN user_tab_comments c ON t.TABLE_NAME = c.TABLE_NAME
WHERE
  t.OWNER = '******'
ORDER BY
  t.num_rows DESC;