|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.
$ 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
Thanks for pointing that out. I've corrected the typo in both places now.