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%'; |