We've recently started exploring EnterpriseDB as a replacement to Oracle. Can anyone please help me to know the list of invalid objects in DB?
As per docs DBA_OBJECTS.STATUS is maintained for compatibility
Thanks in advance..
The status column in dba_object is included for compatibility only, and it is always set to VALID.
Please find below link for more details:
Hope this answers your question.
Thanks for Reply. I was looking for a way to find the status of the object whether is VALID or NOT since DBA_OBJECTS is not helping.
We can check invalid indexes. However, There is no way list up 'invalid' objects in PostgreSQL, since other objects cannot become invalid in PostgreSQL.
Oracle and PostgreSQL work quite differently in that respect :
In Oracle, you can always ALTER an object (for example a table) even if there are dependent objects (for example views). The dependent objects then become invalid and have to be recompiled.
In PostgreSQL, you cannot ALTER an object that has dependent objects in a way that renders these dependent objects invalid. You have to drop and recreate the dependent objects.
Invalid indexes can be left behind by a failed CREATE INDEX command.
As mentioned earlier, In EPAS, The status column in dba_object is included for compatibility only, and it is always set to VALID.
Hope this helps.