SQL Developer (MOSC)

MOSC Banner

Removing relationships while preserving generated attributes in SQL Developer Data Modeler

Hi,

We need to remove some relationships between entities in our logical model in Oracle SQL Developer Data Modeler. However, we would like to keep the attributes that were originally generated as a result of those relationships (for example, migrated attributes/foreign key attributes).
Is there a specific feature or recommended procedure that allows us to delete a relationship without automatically removing the associated generated attributes from the entities?

We understand that migrated attributes are owned by the relationship and that one possible workaround is to manually create equivalent non-migrated attributes in the child entity before deleting the relationship. However, we would like to know whether there is any alternative or built-in method to achieve this, especially in cases where a large number of relationships and migrated attributes are involved.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center