Re: integrity-check of DB Constraints

From: Patrick Held <pheld_at_de.oracle.com>
Date: Mon, 16 Aug 1999 10:52:15 +0200
Message-ID: <37B7D13E.E76AA823@de.oracle.com>

Hi Hth,

the goal is to write a Script that checks every constraint of the Oracle Apps
Database. If the constraint is disabled the script should display it on the screen or optionally print it out.
You said that I could not reverse-engineer Oracle Apps DB into Designer; can

constraints change dynamically?
Do you know any literature where to get more info about constraints? I checked
the Oracle8 Application Developer's Guide but it doesn't tell me much about constraints.

Thanx!

Patrick

Patrick Held schrieb:

> Hi,
>
> I am trying to ceate a SQL or PL/SQL statement that automatically checks
> the integrity of the database constraints of the Oracle Applications
> Database. There might be a solution entering the ERD into the designer
> and letting it generate the apropriate SQL.
> Are there any alternatives to that vague solution?
>
> many many thanks to the helping people!
>
> Patrick
Received on Mon Aug 16 1999 - 03:52:15 CDT