Feature Details

Add support for editioning views in data modeler

We're preparing to use edition-based redefinition in our databases so we need to convert our views to have the keyword EDITIONING in the CREATE VIEW statement. This means we need to go into the definition and update these manually (or write a transformation) in the physical model.

It would be better if there was a boolean attribute for Oracle views that set whether it is editioning or not and the DDL was updated as appropriate.

The editioning property should also be set when importing from a data dictionary - currently this informaiton is lost.

Average Rating

Status

Open

Ratings/ Comments

Comment	Score	Created On
It would be cool to use Data Modeler for creating "multi editioned" models to see the history of the database scheme. Maybe it's not a trivial task, but it worth to do for complete support of this feature. At least it would be very useful to have possibility to use the Editioning Views in the "single edition" model.	10	17-NOV-14
Needed. Also the import part.	10	07-JAN-13
	10	11-DEC-12
This is definitely lacking and a boolean attribute would certainly remove the need for writing script for this. Editioning in general is not currently catered for at all so the ability to construct "editions" in ODM and to link object to them in the physical model would seem like the obvious thing to introduce.	10	11-DEC-12
	10	07-DEC-12

1 - 5