| 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.
I should have stated in my post that the tables do get exported
successfully. It is during the export of the views that the error is
generated.
-----Original Message-----
From: Blizzard, Michael [mailto:Michael.Blizzard_at_aig.com]
Sent: Monday, August 07, 2000 1:59 PM
To: 'Grabowy, Chris'
Subject: RE: "ORA-01436: CONNECT BY loop in user data" during export.
Is this nt. If so. try setting the sid to the database you are trying to export first.
-----Original Message-----
From: Grabowy, Chris [mailto:cgrabowy_at_fcg.com]
Sent: Monday, August 07, 2000 1:46 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"
 |
 |