My Oracle Support Banner

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:

Enterprise Manager for Oracle Database - Version and later
Information in this document applies to any platform.


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)?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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