In Grid Enterprise Manager Database Data Masking Tool Cannot Define Manual Referential Relationships Between Tables (Doc ID 2899100.1)

Last updated on DECEMBER 08, 2022

Applies to:

Goal

Using an exiting Application Data Model, when attempting to manually define an undiscovered referential relationship between two table via "Add Referential Relationship":

What are the requirement for table columns to be displayed here, so that a manual referential relationship can be entered for cascaded masking (to preserve deterministic referential integrity)?

Do the tables need to have both a PRIMARY and FOREIGN key defines as a constraint (which would registered in the Oracle Data Dictionary)?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.