Follow us: Subscribe via RSS Feed Connect on YouTube Connect on YouTube

Pages

Sunday, 5 February 2017

Query to Check Database for Invalid Objects


The relevant query is as follows:

SELECT owner, object_name, object_type
FROM     all_objects
WHERE  status = ‘INVALID’;

SELECT count(*)
FROM   from dba_objects
WHERE  status = ‘INVALID’;



Share this article :

0 comments:

Post a Comment