How will you find Invalid Objects in database ?

Q

How will you find Invalid Objects in database ?

✍: Guest

A

using query SQLPLUS> select count(*) from dba_objects where status like 'INVALID';

2011-12-27, 2655👍, 0💬