Comments
| 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... Hi.Thanks for pointing that out. I've corrected the typo in both places now. Cheers Tim... |
DO NOT ask technical questions here, that's what my forum is for!
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!