Automic Workload Automation

  • Private Community
 View Only
Back to discussions
Expand all | Collapse all

Data Consistency Check (ORA-02270 occurred)

  • 1.  Data Consistency Check (ORA-02270 occurred)

    Posted Feb 17, 2017 05:45 AM
    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: https://community.automic.com/discussion/7877/