Sunday , November 2 2025

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

Check Invalid Objects In Oracle

Buğra PARLAYAN February 13, 2023 ORACLE

In today’s article we will learn How to See Invalid Object in Oracle Database.

We can See Invalid Object using the following code block.

SELECT OWNER
	,object_type
	,object_name
	,STATUS
FROM dba_objects
WHERE STATUS = 'INVALID'
ORDER BY OWNER
	,object_type
	,object_name;

SELECT OWNER

,object_type

,object_name

,STATUS

FROM dba_objects

WHERE STATUS = 'INVALID'

ORDER BY OWNER

,object_type

,object_name;

About Buğra PARLAYAN

Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical / relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat & Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.

Check Invalid Objects In Oracle

About Buğra PARLAYAN

Leave a Reply Cancel reply