DBA_EDITIONING_VIEWS_AE view tips

Oracle Tips by Burleson Consulting

DBA_EDITIONING_VIEWS_AE

<< Return to the index

Oracle 11g makes the following comments about the DBA_EDITIONING_VIEWS_AE table: "Description of all Editioning Views in the database"

Column description of the DBA_EDITIONING_VIEWS_AE view:

OWNER

Description of DBA_EDITIONING_VIEWS_AE.OWNER: "Owner of an Editioning View"

VIEW_NAME

Description of DBA_EDITIONING_VIEWS_AE.VIEW_NAME: "Name of an Editioning View"

TABLE_NAME

Description of DBA_EDITIONING_VIEWS_AE.TABLE_NAME: "Name of an Editioning View's base table"

EDITION_NAME

Description of DBA_EDITIONING_VIEWS_AE.EDITION_NAME: "Name of the Application Edition where the Editioning View is defined"

DBA_EDITIONING_VIEWS_AE View Source

Oracle 11g's data dictionary defines the DBA_EDITIONING_VIEWS_AE view using the following source query:

select ev_user.name, ev_obj.name, ev.base_tbl_name, ev_obj.defining_edition
from sys."_ACTUAL_EDITION_OBJ" ev_obj, sys.ev$ ev, sys.user$ ev_user
where
/* join EV$ to _ACTUAL_EDITION_OBJ on EV id so we can determine */
/* name of the EV and id of its owner */
ev_obj.obj# = ev.ev_obj#
/* join _ACTUAL_EDITION_OBJ row pertaining to EV to USER$ to get */
/* EV owner name */
and ev_obj.owner# = ev_user.user#

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.
You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books