Oracle Database CHECK NUMBER For tables/views/triggers/function/procedure

 

 

SELECT DISTINCT(TABLESPACE_NAME) FROM ALL_TABLES;

SELECT COUNT(*) FROM ALL_TABLES WHERE TABLESPACE_NAME='xx' ORDER BY TABLE_NAME ASC;
--COUNT 384
SELECT COUNT(*) FROM ALL_VIEWS  WHERE OWNER='xx';
--COUNT 169
select COUNT(*) from USER_TRIGGERS;
--COUNT 134
SELECT OBJECT_NAME,OBJECT_TYPE FROM ALL_OBJECTS WHERE OBJECT_TYPE IN ('FUNCTION','PROCEDURE') AND OWNER='xx';
--COUNT 8