Data Dictionary Documentor

[mdav2]

Does anyone know of any software (other than TOAD DATA MODELLER) that would create a data dictionary document which includes:

* Table definitions (name, fields, types and comments)
* Indexes
* Relationships

Thanks,

Mark

Mark Davies
Warwickshire County Council

 

[LKBrwnDBA]

Plato.




----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[LKBrwnDBA]

PS: Also...

Visio, ERwin, ... and other similar ...

DDL Wizard / SQL Developer to reverse engineer schema.






----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[SantaMufasa]

Mark,

Bear in mind that it would not take much to create a query to do what you want.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
A fo ben, bid bont.

 

[LKBrwnDBA]

But it's allways nice to be able to just point and click to get a report.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[SantaMufasa]

But it's allways nice to be able to just point and click to get a report.

True...but in my (pocket) book, it's even nicer to get what I want without additional cost, forever.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
A fo ben, bid bont.

 

[LKBrwnDBA]

Well, Plato, DDL Wizard and SQL Developer are free!



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[SantaMufasa]

Well, Plato, DDL Wizard and SQL Developer are free!

Even better !

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
A fo ben, bid bont.

 

[mdav2]

Cheers for all the responses, will have a look into these. Have used SQL Developer but only in training course so not familiar with all its functionality. Everyone likes free and my Oracle database knowledge outside general queries isn't that hot. Could ask our DBA's to write something.

Mark Davies
Warwickshire County Council

 

[ChrisHunt]

Not exactly what you asked for, but you (and others) might want to take a look at SchemaSpy -

http://schemaspy.sourceforge.net/

It generates a stack of interlinked HTML pages which describe your database, there's an example at

http://schemaspy.sourceforge.net/sample/

I particularly like the way it generates mini ER diagrams for each table - a handy way to explore an unfamiliar system.

-- Chris Hunt
Webmaster & Tragedian
Extra Connections Ltd