CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

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
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [119 users online]    © 2010 psoug.org