Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: "ORA-01436: CONNECT BY loop in user data" during export.

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

From: Grabowy, Chris <cgrabowy_at_fcg.com>
Date: Mon, 7 Aug 2000 14:36:52 -0400
Message-Id: <10582.113995@fatcity.com>


During the import the tables get created and populated but no views are created. The import errors off because of an expected end of file.

-----Original Message-----
From: Sandeep Kurliye [mailto:Sandeep.Kurliye_at_almarai.com] Sent: Monday, August 07, 2000 2:19 PM
To: Grabowy, Chris; Fatcity's Oracle ListServ; LazyDBA's Oracle ListServ Subject: RE: "ORA-01436: CONNECT BY loop in user data" during export.

        Is there any views also getting exported??? I guess - View definition is causing problem.

        Just a guess....

	Sandeep.
	Riyadh, Saudi Arabia.


	-----Original Message-----
	From:	Grabowy, Chris [SMTP:cgrabowy_at_fcg.com]
	Sent:	Monday, August 07, 2000 11:16 PM
	To:	Fatcity's Oracle ListServ; LazyDBA's Oracle ListServ
	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"


	--------
	If you're bored, then visit the list's website:
http://www.lazydba.com (updated daily)
	to unsubscribe, send a blank email to
oracledba-unsubscribe_at_quickdoc.co.uk
	to subscribe send a blank email to
Received on Mon Aug 07 2000 - 13:36:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US