In today’s article, How Can I See Invalid Object in Oracle Database? I will be answering the question.
We can see with the help of the code block below.
1 2 3 4 5 6 7 8 9 | SELECT OWNER ,object_type ,object_name ,STATUS FROM dba_objects WHERE STATUS = 'INVALID' ORDER BY OWNER ,object_type ,object_name; |