| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: "ORA-01436: CONNECT BY loop in user data" during export.
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_01C000A0.22F0BD86
Content-Type: text/plain;
charset="iso-8859-1"
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]
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_01C000A0.22F0BD86 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printableReceived on Mon Aug 07 2000 - 13:48:53 CDT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: "ORA-01436: CONNECT BY loop in user data" during =
export.</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Hi Chris, </FONT>
</P>
<P><FONT SIZE=3D2>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?</FONT></P>
<P><FONT SIZE=3D2>nooooooooooooooooooooo!!!!</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Grabowy, Chris [<A =
HREF=3D"mailto:cgrabowy_at_fcg.com">mailto:cgrabowy_at_fcg.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Monday, August 07, 2000 2:55 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: "ORA-01436: CONNECT BY loop in user =
data" during export.</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>I receive the following error when I export a schema =
on a Oracle 8.1.6</FONT>
<BR><FONT SIZE=3D2>database.</FONT>
</P>
<P><FONT SIZE=3D2>EXP-00056: ORACLE error 1436 encountered </FONT>
<BR><FONT SIZE=3D2>ORA-01436: CONNECT BY loop in user data </FONT>
<BR><FONT SIZE=3D2>EXP-00000: Export terminated unsuccessfully </FONT>
</P>
<P><FONT SIZE=3D2>One of the schemas on that database originally came =
from an Oracle 7.3.4</FONT>
<BR><FONT SIZE=3D2>database. I have opened up "yet another =
unresponsive" iTAR. There is a</FONT>
<BR><FONT SIZE=3D2>known bug involving views corrupting the dictionary, =
causing exports to</FONT>
<BR><FONT SIZE=3D2>fail. OWS responded with a series of scripts =
to identify and cleanup the</FONT>
<BR><FONT SIZE=3D2>dictionary, but the "identify" script also =
returns ORA-01436. Which means</FONT>
<BR><FONT SIZE=3D2>the "cleanup" script has nothing to =
cleanup.</FONT>
</P>
<P><FONT SIZE=3D2>So I was wondering if anyone else has encountered =
this problem, and what has</FONT>
<BR><FONT SIZE=3D2>been done??</FONT>
</P>
<P><FONT SIZE=3D2>TIA</FONT>
</P>
<P><FONT SIZE=3D2>Chris Grabowy</FONT>
<BR><FONT SIZE=3D2>"May Oracle be with you...always"</FONT>
</P>
<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Grabowy, Chris</FONT>
<BR><FONT SIZE=3D2> INET: cgrabowy_at_fcg.com</FONT>
</P>
<P><FONT SIZE=3D2>Fat City Network Services -- (858) =
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------= -----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
from). You may</FONT>
<BR><FONT SIZE=3D2>also send the HELP command for other information =
 |
 |