ORACLE sql查询用户/表/数据/外键/主键/索引

查询用户数量

--  查询用户数量
SELECT COUNT(*) AS user_count FROM DBA_USERS;
SELECT COUNT(*) AS user_count FROM USER_TABLES;

查询表数量

--  查询表数量
SELECT OWNER, COUNT(*) AS table_count
FROM DBA_TABLES
WHERE OWNER IN ('RBCC_ICO_ADMIN', 'DPDB_CONFIDENTIAL', 'DPDB_INTERNAL')
GROUP BY OWNER;

检查数据记录数量

--  检查数据记录数量
SELECT OWNER, SUM(NUM_ROWS) AS NUM_ROWS
FROM DBA_TABLES
WHERE OWNER IN ('xxx', 'xxx', 'xxx')
GROUP BY OWNER;

检查约束数量: 主键/外键

--  检查约束数量: 主键/外键
SELECT OWNER, COUNT(1) COUTS
FROM all_constraints
WHERE OWNER IN ('xxx', 'xxx', 'xxx')
    AND constraint_type IN ('P', 'R')
GROUP BY OWNER;

检查约束数量: 索引

--  检查约束数量: 索引
SELECT OWNER, COUNT(1) COUTS
FROM all_indexes
WHERE OWNER IN ('xxx', 'xxx', 'xxx')
GROUP BY OWNER;

 

posted @   Robot-Blog  阅读(45)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 阿里最新开源QwQ-32B,效果媲美deepseek-r1满血版,部署成本又又又降低了!
· 单线程的Redis速度为什么快?
· SQL Server 2025 AI相关能力初探
· AI编程工具终极对决:字节Trae VS Cursor,谁才是开发者新宠?
· 展开说说关于C#中ORM框架的用法!
点击右上角即可分享
微信分享提示