3

As per Oracle's documentation, since version 11g, Edition Based Redefinition (EBR) is initialized with a default edition named ORA$BASE. Any future EBRs are children of this so-called "edition".

I've checked the documentation, but it doesn't say how to check if a database has been "edition enabled" or not, or whether EBR is in use.

Edition-Based Redefinition Technical Deep Dive (Oracle | PDF)

Is EBR in use if the following query below shows more than ORA$BASE as the existing edition or not necessarily?

SELECT * FROM dba_editions;

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.