EBR – Data Dictionary

Now I’d like to cover some aspects of the Oracle Data Dictionary to explain some details about EBR.

First lets check what edition the current session is working in.

SQL> EXEC DBMS_OUTPUT.PUT_LINE(SYS_CONTEXT('USERENV', 'SESSION_EDITION_NAME'));
ORA$BASE

Next lets look at the objects we created in the last post.

SQL> SELECT object_name,
 2          object_type,
 3          editionable,
 4          edition_name
 5     FROM user_objects;

OBJECT_NAME     OBJECT_TYPE             E EDITION_NA
--------------- ----------------------- - ----------
DEMO            TABLE
DEMO_VIEW       VIEW                    Y ORA$BASE
J               JOB
P               PROCEDURE               Y ORA$BASE
SET_EDITION     TRIGGER                 Y ORA$BASE

The view, procedure and trigger are editionable (yay for them!) which so they can differ across editions. The EDITION_NAME column displays the edition they were created in. The other objects (most notably the TABLE) are NOT editionable.