Hi i have requirement to drop all invalid objects in database where user no longer exists in database, it is documented by oracle that if a cascade drop is performed on a userid that objects like MV & synonyms etc.. will become INVALID but will not be dropped from database.
Anybody has any idea how we can find such INVALID objects of users whose id is dropped from database.
Appreciate your help in advance.
Thanks
Abhinay