Schema checks for Oracle

[hudatolah]

Code: Select all

select * from dba_tablespace_usage_metrics order by used_percent;

SELECT OWNER, object_type, object_name,Status FROM all_objects where status = 'INVALID' and object_type = 'VIEW';

COMPILE_SCHEMA is a stored procedure that we can’t execute or don’t have permission to see it. 

EXEC DBMS_UTILITY.COMPILE_SCHEMA -- gives : Could not find stored procedure 'DBMS_UTILITY.COMPILE_SCHEMA'.