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

Home » Misc » Here

Comments for Edition Based Redefinition in 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.



Jacek said...

Hey Tim.
Great Article and a nice description of a feature.
Would be nice to give it a try.
Thank you for spending time to prepare and share it.

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!