We need support for Edition-Based Redefinition (EBR) soon

Toad for Oracle Idea Pond
1

For several years, Oracle has editionable objects (EBR - Edition-Based Redefinition).

Edition-based redefinition allows multiple versions of PL/SQL objects, views and synonyms in a single schema.
We work with EBR, but TOAD don't support EBR, so we can't use TOAD for EBR's work.
When will TOAD support EBR?

Thanks,

Jeronimo

2

Hi Jeronimo,

Toad already supports EBR, but it is limited to creating and managing Editions in the Schema Browser. Could you please detail what else you would be looking for?

Thanks,

John

3

I would like to set an edition in relation to a session (and all related sessions, because Toad uses more then a single session in some cases). Toad should also be able switch the edition in case a script is executed with sqlplus (started by toad). This would make it possible to edit editionable objects in the desired edition and to view dictionary data in the wanted context.

4

Ah, so you are doing an “alter session set edition” and you want Toad to run it in background sessions too.

Go to Options -> Oracle -> Roles and Editions. You might need to reconnect after that (can’t remember off top of my head).