Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links


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.


Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired