cancel
Showing results for 
Search instead for 
Did you mean: 

List of Invalid Objects

Adventurer

List of Invalid Objects

Hi Team,

 

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.. 

3 REPLIES 3
Highlighted
Level 3 Adventurer

Re: List of Invalid Objects

Hi Kaushik,

 

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:

https://www.enterprisedb.com/docs/en/11.0/EPAS_Oracompat_Ref_Guide_v11/Database_Compatibility_for_Or...

 

Hope this answers your question.

Adventurer

Re: List of Invalid Objects

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. 

 

EDB Team Member

Re: List of Invalid Objects

Hi Kaushik,

 

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.