dbms_metadata & dbms_system compatibility in EDB

Level 3 Traveller

dbms_metadata & dbms_system compatibility in EDB

Hi Team,

Our oracle application uses the packages dbms_metadata and dbms_system. Please let us know whether we have this package in the compatibility layer or work around



Balu s

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.


Re: dbms_metadata & dbms_system compatibility in EDB

Hi Balu, 


These are oracle database specific packages. These are more of less related to the functioning of the oracle database. From what I was ableto understand dbms_metadata is about retrieving metadata and dbms_system is about setting environment varials or sql traces etc. Since the way Oracle and Postgres function from the backend is not similar so using the same pacakges wont be of any use. 


In order to guide you further on this, it would help if you could explain what you achieve using these packages and we can share the equivalent ways to achieve the same in Postgres or EDB Postgres.


Cheers, Amit 

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