RE: "ORA-01436: CONNECT BY loop in user data" during export.

From: Grabowy, Chris <cgrabowy_at_fcg.com>
Date: Mon, 7 Aug 2000 15:26:13 -0400
Message-Id: <10582.114002@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_01C000A5.79703718
Content-Type: text/plain;

charset="iso-8859-1"

Yes, it is Oracle 8.1.6, running on Solaris 2.7. I think I surprised OWS when I responded to them that the "identify the bad rows" script also returned the error. The iTAR mentions that this is supposed to be fixed in 8.1.7 and 8.2, which doesn't help cause I'm not upgrading. Backport it baby...

-----Original Message-----
From: Koivu, Lisa [mailto:lkoivu_at_qode.com] Sent: Monday, August 07, 2000 2:49 PM
To: 'ORACLE-L_at_fatcity.com'; 'cgrabowy_at_fcg.com' Subject: RE: "ORA-01436: CONNECT BY loop in user data" during export.

Hi Chris,

Yes I've run into this too, we are 8.1.5 HPUX. I get it when I select * from DBA_OBJ_DEPENDENCIES. The only way out of this particular mess for us is upgrade to 8.1.6 (per support). It's the root of a lot of other bugs in our version. But you are seeing this in 8.1.6??? Now I'm scared. What OS are you running?

nooooooooooooooooooooo!!!!

-----Original Message-----
From: Grabowy, Chris [ mailto:cgrabowy_at_fcg.com <mailto:cgrabowy_at_fcg.com> ] Sent: Monday, August 07, 2000 2:55 PM
To: Multiple recipients of list ORACLE-L Subject: "ORA-01436: CONNECT BY loop in user data" during export.

I receive the following error when I export a schema on a Oracle 8.1.6 database.

EXP-00056: ORACLE error 1436 encountered 
ORA-01436: CONNECT BY loop in user data 
EXP-00000: Export terminated unsuccessfully

One of the schemas on that database originally came from an Oracle 7.3.4 database. I have opened up "yet another unresponsive" iTAR. There is a known bug involving views corrupting the dictionary, causing exports to fail. OWS responded with a series of scripts to identify and cleanup the dictionary, but the "identify" script also returns ORA-01436. Which means the "cleanup" script has nothing to cleanup.

So I was wondering if anyone else has encountered this problem, and what has

been done??

TIA Chris Grabowy
"May Oracle be with you...always"

-- 
Author: Grabowy, Chris 
  INET: cgrabowy_at_fcg.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). 


------_=_NextPart_001_01C000A5.79703718
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">

<TITLE>RE: "ORA-01436: CONNECT BY loop in user data" during export.</TITLE>




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

<BODY>

<DIV><SPAN class=020540119-07082000><FONT face=Arial color=#0000ff size=2>Yes, 

it is Oracle 8.1.6, running on Solaris 2.7.&nbsp; I think I surprised OWS when I 
responded to them that the "identify the bad rows" script also returned the 
error.&nbsp; The iTAR mentions that this is supposed to be fixed in 8.1.7 and 
8.2, which doesn't help cause I'm not upgrading.&nbsp; Backport it 
baby...</FONT></SPAN></DIV>


<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">

  <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma 
  size=2>-----Original Message-----<BR><B>From:</B> Koivu, Lisa 
  [mailto:lkoivu_at_qode.com]<BR><B>Sent:</B> Monday, August 07, 2000 2:49 
  PM<BR><B>To:</B> 'ORACLE-L_at_fatcity.com'; 'cgrabowy_at_fcg.com'<BR><B>Subject:</B> 
  RE: "ORA-01436: CONNECT BY loop in user data" during 
  export.<BR><BR></FONT></DIV>
  <P><FONT size=2>Hi Chris, </FONT></P>
  <P><FONT size=2>Yes I've run into this too, we are 8.1.5 HPUX.&nbsp; I get it 
  when I select * from DBA_OBJ_DEPENDENCIES.&nbsp; The only way out of this 
  particular mess for us is upgrade to 8.1.6 (per support).&nbsp; It's the root 
  of a lot of other bugs in our version. But you are seeing this in 
  8.1.6???&nbsp; Now I'm scared.&nbsp; What OS are you running?</FONT></P>
  <P><FONT size=2>nooooooooooooooooooooo!!!!</FONT> </P>
  <P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From: 
  Grabowy, Chris [<A 
  href="mailto:cgrabowy_at_fcg.com">mailto:cgrabowy_at_fcg.com</A>]</FONT> <BR><FONT 
  size=2>Sent: Monday, August 07, 2000 2:55 PM</FONT> <BR><FONT size=2>To: 
  Multiple recipients of list ORACLE-L</FONT> <BR><FONT size=2>Subject: 
  "ORA-01436: CONNECT BY loop in user data" during export.</FONT> </P><BR>
  <P><FONT size=2>I receive the following error when I export a schema on a 
  Oracle 8.1.6</FONT> <BR><FONT size=2>database.</FONT> </P>
  <P><FONT size=2>EXP-00056: ORACLE error 1436 encountered </FONT><BR><FONT 
  size=2>ORA-01436: CONNECT BY loop in user data </FONT><BR><FONT 
  size=2>EXP-00000: Export terminated unsuccessfully </FONT></P>
  <P><FONT size=2>One of the schemas on that database originally came from an 
  Oracle 7.3.4</FONT> <BR><FONT size=2>database.&nbsp; I have opened up "yet 
  another unresponsive" iTAR.&nbsp; There is a</FONT> <BR><FONT size=2>known bug 
  involving views corrupting the dictionary, causing exports to</FONT> <BR><FONT 
  size=2>fail.&nbsp; OWS responded with a series of scripts to identify and 
  cleanup the</FONT> <BR><FONT size=2>dictionary, but the "identify" script also 
  returns ORA-01436.&nbsp; Which means</FONT> <BR><FONT size=2>the "cleanup" 
  script has nothing to cleanup.</FONT> </P>
  <P><FONT size=2>So I was wondering if anyone else has encountered this 
  problem, and what has</FONT> <BR><FONT size=2>been done??</FONT> </P>
  <P><FONT size=2>TIA</FONT> </P>
  <P><FONT size=2>Chris Grabowy</FONT> <BR><FONT size=2>"May Oracle be with 
  you...always"</FONT> </P>
  <P><FONT size=2>-- </FONT><BR><FONT size=2>Author: Grabowy, Chris</FONT> 
  <BR><FONT size=2>&nbsp; INET: cgrabowy_at_fcg.com</FONT> </P>
  <P><FONT size=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 
  538-5051&nbsp; FAX: (858) 538-5051</FONT> <BR><FONT size=2>San Diego, 
  California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access 
  / Mailing Lists</FONT> <BR><FONT 
  size=2>--------------------------------------------------------------------</FONT> 
  <BR><FONT size=2>To REMOVE yourself from this mailing list, send an E-Mail 
  message</FONT> <BR><FONT size=2>to: ListGuru_at_fatcity.com (note EXACT spelling 
  of 'ListGuru') and in</FONT> <BR><FONT size=2>the message BODY, include a line 
  containing: UNSUB ORACLE-L</FONT> <BR><FONT size=2>(or the name of mailing 
  list you want to be removed from).&nbsp; You may</FONT> <BR><FONT size=2>also 
  send the HELP command for other information (like subscribing).</FONT>

Received on Mon Aug 07 2000 - 14:26:13 CDT