8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 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!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.