$page_title = $titlebar_text; $header_bar_text = $titlebar_text; ///////////////////////////////////// // get header include('rlib_header.php'); // print << Oracle Editions Version 11.1  
General
Dependent Objects
edition$ _ACTUAL_EDITION_OBJ _CURRENT_EDITION_OBJ
     
DBA ALL USER
dba_editioning_views all_editioning_views user_editioning_views
dba_editioning_views_ae all_editioning_views_ae user_editioning_views_ae
dba_editions all_editions user_editions
dba_edition_comments all_edition_comments  
Related System Privileges create any edition
alter any edition
drop any edition
Related Object Privileges use
GRANT use ON edition ora$base TO public;
 
Create Edition
Full Create Edition Syntax CREATE EDITION <edition_name>
Create Sequence Simplest Form CREATE SEQUENCE <sequence_name>;
desc dba_editions

SELECT *
FROM dba_editions;

CREATE EDITION ora$base;
 
Alter Edition
Alter Edition Object ALTER EDITION <edition_name> <USABLE | UNUSABLE>;
ALTER EDITION ora$base UNUSABLE;
 
Drop Edition
Drop Edition Object DROP EDITION <edition_name> [CASCADE];
DROP EDITION ora$base CASCADE;
 
Sequence Related Queries
Object Information conn / as sysdba

desc obj$

set linesize 121

SELECT obj#, name, namespace, type#, status, spare3
FROM obj$
WHERE name = 'ORA$BASE';
Last Number Selected From Sequence conn / as sysdba

desc props$

set linesize 121
col value$ format a30
col comment$ format a40

SELECT *
FROM props$
WHERE name LIKE '%EDITION%';
Related Auditing conn / as sysdba

desc audit_actions

SELECT *
FROM audit_actions
WHERE name LIKE '%EDITION%';
 
Related Topics
dbms_editions_utilities
Users
  EOM; ///////////////////////////////////// // get footer include('rlib_footer.php'); ?>