Skip to Main Content
  • Questions

  • How to find database objects different versions with edition-based redefinition

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Girish.

Asked: November 07, 2023 - 11:32 am UTC

Last updated: November 09, 2023 - 4:59 am UTC

Version: 19.0.0.0.0

Viewed 1000+ times

You Asked

Hello,

We are using EBR for deployment of DB objects. If any objects released in EBR in different editions need your help where to find the different versions(source code) of database objects (functions,procedure,package) stored in database as we are using EBR.

Is there any table maintained for storing different versions of same object.

Regards
GirishR

and Chris said...

Many of the dictionary views have an _AE (all editions) version. These show you which editions have which objects in them.

e.g.

DBA/ALL/USER_OBJECT_AE
DBA/ALL/USER_SOURCE_AE
DBA/ALL/USER_TRIGGERS_AE
DBA/ALL/USER_VIEWS_AE

https://docs.oracle.com/en/database/oracle/oracle-database/19/adfns/editions.html#GUID-1B0311B5-CBC7-43E2-9EA0-37DE2E670508

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

A reader, November 08, 2023 - 5:07 am UTC

This information is really helpful. Thanks for your quick help.
Connor McDonald
November 09, 2023 - 4:59 am UTC

nice to see someone taking advantage of EBR - its a super cool feature
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library