oracle 查询数据库表的数量

SELECT OWNER,COUNT(*) FROM ALL_TABLES GROUP BY OWNER;

SELECT * FROM ALL_TABLES WHERE OWNER = '用户名'

SELECT COUNT(*) FROM TABS

SELECT COUNT(*) FROM USER_TABLES;