Script to Check Object Status In Oracle


The below script can be used to checkĀ  object status in oracle database , usually performed before and after the upgrade.

 

SQL> select owner,object_type,count(*) from dba_objects group by owner,object_type;

 

[adrotate group=”1″]

 

Run this command before and after upgrade . Compare the results to check if any objects became invalid after the upgrade.

 

 

Hope this helps .

Wysheid Team

Leave a comment

Your email address will not be published. Required fields are marked *

We assure our best to meet up to your expectations

Your Feedback will help us

Glad That You Liked It

Your Feedback will help us to improve