"ORA-01436: CONNECT-BY loop in user data" errors in 8.1.6

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Mon, 7 Aug 2000 16:51:23 -0400
Message-Id: <10582.114012@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_01C000B1.42E3D414
Content-Type: text/plain;

charset="iso-8859-1"

Hello all,

Chris has scared me. Is anyone running 8.1.6 on HP/UX and running into these problems that Chris described earlier (shown below)?

HELP! We are in sad shape with this error in 8.1.5 and were looking forward to upgrading to 8.1.6 to get out of this mess and to use some new features. This error renders DBMS_UTILITY.COMPILE_SCHEMA useless.

Thanks
Lisa

Before 8.1.6, this schema was on 7.3.4. In production we will be running OPS, so we want to take advantage of the OPS improvements in 8.1.6. If the fix is in 8.1.7 then I'm hoping that they backport it to 8.1.6. The developers hate this bug, because they have to stop developing while I drop the views, export the schema, then put the views back. So everyone will be happy once I get a fix.
What don't you like about HP/UX?

	-----Original Message-----
	From: Koivu, Lisa [mailto:lkoivu_at_qode.com]
	Sent: Monday, August 07, 2000 3:40 PM
	To: 'Grabowy, Chris'
	Subject: RE: "ORA-01436: CONNECT BY loop in user data" during

export.

Lucky dog, running Solaris... wish we were. So far I'm not a fan of HPUX. You didn't have this problem in 8.1.5? Which version are you backporting to?

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

export.

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>] 
			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

Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319

V: 954.484.3191, x174
F: 954.484.2933 
C: 954.658.5849

http://www.qode.com

------_=_NextPart_001_01C000B1.42E3D414
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!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>"ORA-01436: CONNECT-BY loop in user data" errors in = 8.1.6</TITLE>
</HEAD>
<BODY>

Hello all,

Chris has scared me. Is anyone running = 8.1.6 on HP/UX and running into these problems that Chris described = earlier (shown below)?

HELP!  We are in sad shape with = this error in 8.1.5 and were looking forward to upgrading to 8.1.6 to = get out of this mess and to use some new features.  This error = renders DBMS_UTILITY.COMPILE_SCHEMA useless.

<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Lisa</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">***********************</FONT>

Before 8.1.6, this = schema was on 7.3.4. In production we will be running OPS, so we want = to take advantage of the OPS improvements in 8.1.6. If the fix is in = 8.1.7 then I'm hoping that they backport it to 8.1.6.

The developers hate = this bug, because they have to stop developing while I drop the views, = export the schema, then put the views back. So everyone will be happy = once I get a fix.

What don't you like = about HP/UX?

<UL>
<P><FONT SIZE=3D2 FACE=3D"Tahoma">-----Original Message-----<BR>
<B>From:</B> Koivu, Lisa [<A =

HREF=3D"mailto:lkoivu_at_qode.com">mailto:lkoivu_at_qode.com</A>]

<B>Sent:</B> Monday, August 07, 2000 3:40 PM<BR>
<B>To:</B> 'Grabowy, Chris'<BR>
<B>Subject:</B> RE: &quot;ORA-01436: CONNECT BY loop in user data&quot; =

during export. 

 Lucky dog, running = Solaris... wish we were. So far I'm not a fan of HPUX. You didn't have = this problem in 8.1.5? Which version are you backporting = to?

-----Original Message----- From: Grabowy, Chris [<A =
HREF=3D"mailto:cgrabowy_at_fcg.com">mailto:cgrabowy_at_fcg.com</A>] Sent: Monday, August 07, 2000 3:26 PM To: 'Koivu, Lisa'; 'ORACLE-L_at_fatcity.com'; Grabowy, = Chris 
Subject: RE: "ORA-01436: CONNECT BY loop in user = data" during export.

</FONT>
<UL>
<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">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...

<UL>
<P><FONT SIZE=3D2 FACE=3D"Tahoma">-----Original Message-----<BR>
</FONT><B><FONT SIZE=3D2 FACE=3D"Tahoma">From:</FONT></B><FONT SIZE=3D2 =

FACE=3D"Tahoma"> Koivu, Lisa [<A =
HREF=3D"mailto:lkoivu_at_qode.com">mailto:lkoivu_at_qode.com</A>] 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.

</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Times New Roman">Hi Chris,</FONT>=20
<BR><FONT SIZE=3D2 FACE=3D"Times New Roman">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 SIZE=3D2 FACE=3D"Times New =

Roman">nooooooooooooooooooooo!!!!</FONT><FONT FACE=3D"Times New Roman"> =

-----Original = Message----- From: Grabowy, Chris = [<<A =
HREF=3D"mailto:cgrabowy_at_fcg.com">mailto:cgrabowy_at_fcg.com</A>><= /U>] 
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=20
 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<FONT FACE=3D"Times New =

Roman"><BR>
</FONT><FONT SIZE=3D2 FACE=3D"Times New =
Roman">-----------------------------------------------------------------=

---

</P>
<BR>
</UL></UL></UL>
<P><B><FONT SIZE=3D1 FACE=3D"Arial">Lisa Rutland Koivu</FONT></B>
<BR><FONT SIZE=3D1 FACE=3D"Arial">Oracle Database Administrator</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Arial">Qode.com</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Arial">4850 North State Road 7</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Arial">Suite G104</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Arial">Fort Lauderdale, FL&nbsp; =

33319

V: 954.484.3191, x174 Received on Mon Aug 07 2000 - 15:51:23 CDT