Handy Edition Based Redefinition queries

by Granville Bonyata on December 2, 2015

A few queries that are useful to have on hand:

 

SELECT sys_context(‘userenv’,’current_edition_name’) current_edition_name from dual;

ALTER SESSION SET EDITION = R_ABC;

ALTER SESSION SET EDITION = ora$base;

SELECT * FROM dba_editions;

SELECT * FROM database_properties WHERE property_name = ‘DEFAULT_EDITION’;

SELECT * FROM dba_objects_ae WHERE edition_name IS NOT NULL ORDER BY object_type,object_name;

SELECT * FROM dba_editioning_views_ae ORDER BY owner;

SELECT username, editions_enabled FROM dba_users ORDER BY username;

Previous post:

Next post: