Re: Constraints

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 29 Jul 2005 19:50:58 +0200
Message-ID: <60rke19h569q4d4r03i326a8vr91mc1s43@4ax.com>

On Fri, 29 Jul 2005 12:39:08 -0500, "Dale" <dschmitz4_at_cox.net> wrote:

>Can anyone tell me what the following unique constraint means:
>
>ADRI I$PK_VOLUME_HEADER ADRI VOLUME_HEADER VOLUME_ID 1 22 0 ASC
>ADRI I$PK_VOLUME_HEADER ADRI VOLUME_HEADER CIB_VOLUME_ID 2 10 10 ASC
>ADRI I$PK_VOLUME_HEADER ADRI VOLUME_HEADER VOLUME_EDITION 3 22 0 ASC
>ADRI I$PK_VOLUME_HEADER ADRI VOLUME_HEADER VOL_SS 4 2 2 ASC
>
>I can't provide any coherent reason for asking this other than "I can't
>submit more than one record to the volume_header table without violating
>this constraint."
>
>I'm new to Oracle admin and have been tasked with making changes before I
>completely know what I'm doing. Sorry for the paucity of information.
>

It means that the combination of volume_id, cib_volume_id, volume_edition, and vol_ss must be unique.

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Jul 29 2005 - 12:50:58 CDT