ORA-01436 during export on Oracle 8i [message #603194] |
Thu, 12 December 2013 02:28 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/08b09b54ef4bb11e184ad10909c6801d?s=64&d=mm&r=g) |
oraclebabe
Messages: 7 Registered: December 2013
|
Junior Member |
|
|
Hello,
I am trying to do a schema export on 8i (exp system/***@dbname file=xyz.dmp log=xyz.log owner=xyz), but the export ends with the following error:
. exporting views
EXP-00056: ORACLE error 1436 encountered
ORA-01436: CONNECT BY loop in user data
EXP-00000: Export terminated unsuccessfully
This error occurs while exporting the views. The tables are exported successfully.
On MOS, I found DocID 6936881.8, which states that this is caused by 2 views with foreign keys that cross-reference each other and the solution is to disable those contraints.
First of all, is it even possible to have primary and foreign keys directly on views???
And how can I find the views with foreign keys that cross-reference each other? Does anyone have some sort of query for this?
Could it be that the foreign keys that cross-reference each other are actually on the tables? Coz from dba_contraints, I haven't seen any views with pk's and fk's.
In this case, I would expect the export of the tables to give the error message, not the export of the views...
Is there another way to solve this export problem?
Thanks in advance.
|
|
|
Re: ORA-01436 during export on Oracle 8i [message #603203 is a reply to message #603194] |
Thu, 12 December 2013 02:53 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
What I would try is to re-compile the views and see if the error shows up during that.
You can run
SELECT 'alter view ' || view_name || ' compile;' FROM user_views;
as user xyz and then run the resulting script to compile them all.
|
|
|
|
|
|