Re: Vendor Supplied DDL

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 03 Feb 2000 06:58:34 GMT
Message-ID: <38992679.1634768@news.demon.nl>

On Wed, 2 Feb 2000 22:14:35 -0800, "Bill Lindsay" <apogee_at_webspan.net> wrote:

>We have a vendor, who for the time being shall go nameless. They provide
>401K distribution services. when given the DDL for an ORACLE D/B the (40) or
>so tables are defined without Unique Indexes, or Primary Keys. When
>requested to define UNIQUENESS for each table the vendor replied.
>
>"Integrity is built into our application"
>
>What comfort level if any would you from this ?
>
>Thanks
>
>BL
>
>

Depends what those PKs are. If they are meaningless sequence numbers, generated by the application, I would still have concerns. If they are something else: uh oh. Basically, I would probably tell my management I assume no responsibility and start writing scripts to monitor any upcoming problem, in order to nail them down.

Hth,

Sybrand Bakker, Oracle DBA Received on Thu Feb 03 2000 - 00:58:34 CST