RE: Constraints

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Tue, 08 Jan 2002 13:37:18 -0800
Message-ID: <F001.003EA55B.20020108132902@fatcity.com>

CREATE UNIQUE INDEX SYS.I_CON1
ON SYS.CON$(OWNER#,NAME)
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE SYSTEM
STORAGE(INITIAL 16K

        NEXT 96K
        MINEXTENTS 1
        MAXEXTENTS 505
        PCTINCREASE 50
        FREELISTS 1
        FREELIST GROUPS 1
        BUFFER_POOL DEFAULT)

LOGGING
NOPARALLEL
/

-----Original Message-----
Sent: Tuesday, January 08, 2002 3:53 PM
To: Multiple recipients of list ORACLE-L

Tell me if I have this right ......

There are not supposed to be any Duplicate Constraint names in your Database, right ??

Right now I have a database that has 48 constraints that are duplicated in name. They are constraints that have a system generated name.

Its on Oracle 8.0.5. Anyone know of any known bug that would allow this ?

Thanks

Kevin
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kevin Lange
INET: kgel_at_ppoone.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Khedr, Waleed
INET: Waleed.Khedr_at_FMR.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------