Editions (Oracle)

Edition-based redefinition can be used to upgrade database components while an application is in use. Editions are supported for Oracle 12c and higher. PowerDesigner models editions as extended objects with a stereotype of <<Edition>>.

Creating an Edition

You can create an edition in any of the following ways:

  • Select Model > Editions to access the List of Editions, and click the Add a Row tool.

  • Right-click the model (or a package) in the Browser, and select New > Edition.

Editions are used primarily in conjunction with materialized views. Open the property sheet of a materialized view, select the Physical Options tab, and expand the tree to query_rewrite_clause/unusable_editions_clause to specify editions that the materialized view is unusable before or after.

Edition Properties

You can modify an object's properties from its property sheet. To open an edition property sheet, double-click its Browser in the Editions folder.

The following extensions are available on the General tab:

Name

Description

Parent edition

Specifies that the edition is created as a child of this edition. If no parent is specified, the edition is created as a child of the leaf edition. At the time of its creation, the new edition inherits all editioned objects from its parent edition.

Scripting name: ParentEdition
Parent topic: Oracle