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

From: Sandeep Kurliye <Sandeep.Kurliye_at_almarai.com>
Date: Mon, 7 Aug 2000 21:18:49 +0300
Message-Id: <10582.113994@fatcity.com>

        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:18:49 CDT