List of Invalid Objects

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

Archived Discussions


Effective March 31st, we will no longer engage on PostgresRocks.


How to engage with us further?


  • Thought Leadership: EDB Blogs

  • Tips and Tricks: Postgres Tutorials

  • Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket

  • Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.

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.

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

 

Highlighted
Level 3 Adventurer

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.

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks