Schema checks for Oracle

I decided to add this forum to keep track of solutions for DB related problems.
I have worked with some brilliant people in my life and the solutions to issues that are usually beyond something you can get at Jack in Box Jackson. They deserve historical marker. This is the historical marked on my map.
Pouzivej data base
Post Reply
hudatolah
Site Admin
Posts: 152
Joined: Thu Apr 04, 2013 8:10 pm
Are You a Headhunter?: Affirmative
Surfer?: Yes

Schema checks for Oracle

Post by hudatolah » Mon Aug 01, 2022 1:09 am

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'.
The Blackholesurfer. My surfboard has teeth.
Top
Post Reply

Return to “Database References”