Re: integrity-check of DB Constraints

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Tue, 10 Aug 1999 19:41:11 +0200
Message-ID: <934306881.15263.0.pluto.d4ee154e@news.demon.nl>

Hi Patrick,

What do you mean with integrity. The integrity of the data should be guaranteed as long as those constraints are enabled. That would be a quest to prove Oracle is buggy.
Whether there are not any constraints lacking? You wouldn't discover that if you reverse-engineer the Oracle Applications Database into Designer, because that takes just the current constraints at face value.
Could you please clarify?

Hth,

Sybrand Bakker, Oracle DBA

Patrick Held <patrick.held_at_nortel-dasa.de> wrote in message news:37B0142E.1E511BCB_at_nortel-dasa.de...
> 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 Tue Aug 10 1999 - 12:41:11 CDT