8i | 9i | 10g | 11g | 12c | Misc | PL/SQL | SQL | RAC | Linux

Home » Misc » Here


Edition Based Redefinition in Oracle Database 11g Release 2 - Upgrade database components online using this new feature or Oracle Database 11g Release 2.

Vladimir said...

Thanks, a nice description.

Unfortunately Oracle made the feature sometimes inconsistent. Suppose you made possible for SCOTT to create editions:

grant create any edition, drop any edition to scott;

Then SCOTT creates some edition:

CREATE EDITION some_edition;

From now, SCOTT can enable edition SOME_EDITION in his session.

But if you revoke CREATE ANY EDITION and DROP any EDITION from SCOTT, the ability to enable/disable of SOME_EDITION by SCOTT remains !

I didn't find any place in the data dictionary indicating this relation of SOME_EDITION to SCOTT, formally not existing !

Gary Pennington said...

Your UNIX/Linux examples are not correct.

export ORA_EDITION=ora$base
$ sqlplus username/password@service edition=ora$base

The "$base" part will be translated by the shell, so
you would need to something special to stop it.
For example single quotes 'ora$base' or escape it as in ora\$base

Tim... said...


Thanks for pointing that out. I've corrected the typo in both places now.



DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!