Data Consistency Check (ORA-02270 occurred)

Discussion created by Andreas_Sprosec_7439 on Feb 17, 2017
You Asked

During testing of the upgrade process in test system error ORA-02270 occurred.

To prevent this error we need a script to check the consistency of the data.

and we said ...

We developed a SQL*Plus script (oracle) to find all constraints with type 'R' (Referential (Foreign Key) on a table.

To check if the data are consistent please check out following link: