sql - Vaild objects showing status as 'invalid' in user_objects., -

while executing query below, i'm getting list of object status 'invalid'.,

select * user_objects status='invalid'; 

when checked status of objects individually, in compiled state.,

even after dropping objects, they're still showing when execute same query.,

any clue, why behaving soo?

the possible reason created in schema user_objects table. , table populated data user_objects view.

select * user_tables table_name = 'user_objects' 

execute above query. in case returns rows means found issue. drop user_objects table , start results user_objects view.