RE: Circular FK's

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Sun, 6 Nov 2005 20:53:48 +0100
Message-Id: <20051106195350.67AF221AEBD@turing.freelists.org>

if you are using a hierarchical query for this purpose, you might want to use the CONNECT BY NOCYCLE clause to avoid circular references ...

kind regards,

Lex.  

---

Jonathan Lewis Seminar http://www.naturaljoin.nl/events/seminars.html

---

-----Original Message-----

From: Post, Ethan [mailto:Ethan.Post_at_ps.net] Sent: Friday, November 04, 2005 19:21
To: Lex de Haan; Oracle-L Freelists
Subject: RE: Circular FK's

Let me just tell you a little more about why this is presently a problem. I have a request that I provide dependency trees and table load order for an application with 900+ tables. When I started writing a query to look at this the circular references became quite apparent because I can't find the top of the tree. In this case I have decided to eliminate all tables with circular references from the reporting and state that they must be loaded first and note that they have these e circular references.

--

http://www.freelists.org/webpage/oracle-l Received on Sun Nov 06 2005 - 13:55:49 CST