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