Message-Id: <10582.113996@fatcity.com> From: "Koivu, Lisa" Date: Mon, 7 Aug 2000 14:48:53 -0400 Subject: 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@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@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@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-printable 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@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@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@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 =