Jeff Calico schreef:
> I have inherited a project which seems to have no documentation. There
> are some 50 - 60 tables as well as sequences, indexes, constraints...
> I can find no sql script to look at that creates all these objects.
>
> What is a good way to determine the relationships between the various
> tables?
> "Good" meaning some more clever way than me manually looked at
> User_Catalog,
> User_Tables, User_Tab_Columns, etc and drawing a diagram by pencil and
> paper.
>
> Or if I had to do that, a clever SQL query is probably out there that
> would help organize everything...
>
> thanks,
> Jeff
>
I'd say 50-60 tables is about where I would consider a tool,
even one as heavy as Oracle Designer.
It does require some installation (which will take at least
a day!) but it will deliver the required technical implementation
schema in less that 30 minutes.
Now you make the considerations, time wise, whether that
would be an option.
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Wed Sep 06 2006 - 02:49:11 CDT
