RE: Missing foreign key

From: David Barbour <DBarbour_at_connectsouth.com>
Date: Tue, 18 Jul 2000 20:16:21 -0500
Message-Id: <10562.112359@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFF11E.F2AA1950
Content-Type: text/plain;

charset="iso-8859-1"

No. But it was UTF8 as opposed to ASCIIUS7.

David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
dbarbour_at_connectsouth.com

-----Original Message-----
From: Kirsh, Gary [mailto:gary.kirsh_at_gs.com] Sent: Tuesday, July 18, 2000 12:48 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Missing foreign key

David,
Was the export taken from a V7 database? Gary

Gary Kirsh
Next Extent, Inc.

-----Original Message-----
From: David Barbour [mailto:DBarbour_at_connectsouth.com] Sent: Tuesday, July 18, 2000 11:59 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Missing foreign key

Chuck,

Ran into something similar this weekend. I was doing an import after dropping all constraints and truncating all tables. On import, I specified INGNORE=Y, but received the following message:

    . . importing table                     "GLOBDATA"      14851 rows

imported
IMP-00017: following statement failed with ORACLE error 2261:
"ALTER TABLE "GLOBDATA" ADD CONSTRAINT "UNQ_INDEX" UNIQUE

("GDET_UI_ID_INDE"

"X") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 266240
N"
"EXT 126976 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50 FREELISTS 1 FREELIST
"
"GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USER_DATA" ENABLE "
IMP-00003: ORACLE error 2261 encountered ORA-02261: such unique or primary key already exists in the table

Despite the error, the constraint was created, and the data load was successful. Just for grins and giggles, I dropped all the tables, and re-ran the import. THAT returned this error, plus errors on every foreign key.

Anybody else?

David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
dbarbour_at_connectsouth.com

-----Original Message-----
From: Chuck Hamilton [mailto:chuck_hamilton_at_yahoo.com] Sent: Tuesday, July 18, 2000 8:40 AM
To: Multiple recipients of list ORACLE-L Subject: Missing foreign key

Anyone ever encounter a situation where you've had missing parent keys but the foreign key constraint is still enabled? What caused it? We have that situation right now on an 8i database.

Do You Yahoo!?
Get Yahoo! <http://mail.yahoo.com/> Mail - Free email you can access from anywhere!

------_=_NextPart_001_01BFF11E.F2AA1950
Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">


<META content="MSHTML 5.00.2314.1000" name=GENERATOR></HEAD>

<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=746220801-19072000>No.  But it was UTF8 as opposed to ASCIIUS7.</SPAN></FONT></DIV>
<DIV> </DIV>
<P><FONT face=Arial size=2>David A. Barbour</FONT> <BR><FONT face=Arial

size=2>Oracle DBA - ConnectSouth</FONT> <BR><FONT face=Arial 
size=2>512-681-9438</FONT> <BR><FONT face=Arial 
size=2>dbarbour_at_connectsouth.com</FONT> </P>

<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Kirsh, Gary [mailto:gary.kirsh_at_gs.com]<BR><B>Sent:</B> Tuesday, July 18, 2000 12:48 PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE: Missing foreign key<BR><BR></DIV></FONT> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=940483016-18072000>David,</SPAN></FONT></DIV>

  <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=940483016-18072000>Was 
  the export taken from a V7 database?</SPAN></FONT></DIV>
  <DIV><FONT color=#0000ff face=Arial size=2><SPAN

class=940483016-18072000></SPAN></FONT><FONT color=#0000ff face=Arial size=2><SPAN class=940483016-18072000>Gary</SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=940483016-18072000></SPAN></FONT> </DIV>

  <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=940483016-18072000>Gary 
  Kirsh</SPAN></FONT></DIV>
  <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=940483016-18072000>Next

  Extent, Inc.</SPAN></FONT></DIV>
  <BLOCKQUOTE style="MARGIN-RIGHT: 0px">     <DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma     size=2>-----Original Message-----<BR><B>From:</B> David Barbour     [mailto:DBarbour_at_connectsouth.com]<BR><B>Sent:</B> Tuesday, July 18, 2000     11:59 AM<BR><B>To:</B> Multiple recipients of list     ORACLE-L<BR><B>Subject:</B> RE: Missing foreign key<BR><BR></DIV></FONT>     <DIV><FONT color=#0000ff face=Arial size=2><SPAN     class=751200814-18072000>Chuck,</SPAN></FONT></DIV>     <DIV><FONT color=#0000ff face=Arial size=2><SPAN     class=751200814-18072000></SPAN></FONT> </DIV>     <DIV><FONT color=#0000ff face=Arial size=2><SPAN     class=751200814-18072000>Ran into something similar this weekend.  I     was doing an import after dropping all constraints and truncating all     tables.  On import, I specified INGNORE=Y, but received the following     message:</SPAN></FONT></DIV>
    <DIV><FONT color=#0000ff face=Arial size=2><SPAN     class=751200814-18072000></SPAN></FONT> </DIV>     <DIV><FONT color=#0000ff face=Arial size=2><SPAN     class=751200814-18072000>    . . importing     table                         "GLOBDATA"      14851 rows imported<BR>IMP-00017:     following statement failed with ORACLE error 2261:<BR> "ALTER TABLE     "GLOBDATA" ADD  CONSTRAINT "UNQ_INDEX" UNIQUE     ("GDET_UI_ID_INDE"<BR> "X") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS     255 STORAGE(INITIAL 266240 N"<BR> "EXT 126976 MINEXTENTS 1 MAXEXTENTS     121 PCTINCREASE 50 FREELISTS 1 FREELIST "<BR> "GROUPS 1 BUFFER_POOL     DEFAULT) TABLESPACE "USER_DATA" ENABLE "<BR>IMP-00003: ORACLE error 2261     encountered<BR>ORA-02261: such unique or primary key already exists in the     table<BR></SPAN></FONT></DIV>
    <DIV><FONT color=#0000ff face=Arial size=2><SPAN     class=751200814-18072000>Despite the error, the constraint was created, and     the data load was successful.  Just for grins and giggles, I dropped     all the tables, and re-ran the import.  THAT returned this error, plus     errors on every foreign key. </SPAN></FONT></DIV>     <DIV><FONT color=#0000ff face=Arial size=2><SPAN     class=751200814-18072000></SPAN></FONT> </DIV>     <DIV><FONT color=#0000ff face=Arial size=2><SPAN     class=751200814-18072000>Anybody else?</DIV></SPAN></FONT>     <DIV><FONT color=#0000ff face=Arial size=2><SPAN     class=751200814-18072000> </DIV></SPAN></FONT>     <DIV> </DIV>
    <P><FONT face=Arial size=2>David A. Barbour</FONT> <BR><FONT face=Arial

    size=2>Oracle DBA - ConnectSouth</FONT> <BR><FONT face=Arial 
    size=2>512-681-9438</FONT> <BR><FONT face=Arial 
    size=2>dbarbour_at_connectsouth.com</FONT> </P>
    <BLOCKQUOTE>
      <DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma 
      size=2>-----Original Message-----<BR><B>From:</B> Chuck Hamilton 
      [mailto:chuck_hamilton_at_yahoo.com]<BR><B>Sent:</B> Tuesday, July 18, 2000 
      8:40 AM<BR><B>To:</B> Multiple recipients of list 
      ORACLE-L<BR><B>Subject:</B> Missing foreign key<BR><BR></DIV></FONT>Anyone 
      ever encounter a situation where you've had missing parent keys but the 
      foreign key constraint is still enabled? What caused it? We have that 
      situation right now on an 8i database.<BR><BR>
      <P><BR>
      <HR SIZE=1>
      <B>Do You Yahoo!?</B><BR>Get <A href="http://mail.yahoo.com/">Yahoo!

Received on Tue Jul 18 2000 - 20:16:21 CDT