Re: Data model or ER diagram
Date: Mon, 16 Sep 2002 08:46:46 +0000 (UTC)
Message-ID: <3d859b0b.7630762_at_news.btclick.com>
Hi
On Sun, 15 Sep 2002 21:04:53 +0800, "zku" <aperson_at_pd.jaring.my> wrote:
>i recently take over an existing oracle 8i application.
>i have trouble in understand it since the previous team had left the
>company.
>
>any idea on how to retrieve the ER diagram out of it.
>
>i tried oracle designer to do server capture, but it was not successful.
>Many errors.
The DDL to HTML coverter in the freeware DBATool might be of some help to you. Its not quite an ER diagram but it does provide a nicely interlinked HTML documentation tree of your schema showing the DDL structure of each table, index, constraint package etc. and how the objects are related (foreign keys/synonyms/grants etc) to each other.
DBATool: http://www.DataBee.com/dt_home.htm
Regards
Dale Edgar
DataBee: Software that creates small referentially correct Oracle test and development environments at the push of a button. http://www.DataBee.com Received on Mon Sep 16 2002 - 10:46:46 CEST