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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
