Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Data Dictionary pretty-printer
Just a regular user of TOAD . Not a sales pitch.
But, TOAD will definitely do what you want. Reallllly nice Html output with everything in a schema or multiple schemas (you pick 1, 2, or all).
Within a schema Html page, are links to all tables, indexes, triggers, plsql, views, sequences, synonyms, privileges, and summary counts.
All the links (like table link) list all of the tables with detailed info on table columns , views, indexes, etc. The details have links to other lists (like an index goes to the the index list on the particular index).
Anyway, we use to use an in-house tool that needed updating.
Using TOAD was much easier. There is a free version at www.toadsoft.com , but I would guess this feature is not in it. The buy version is at the www.quest.com site and is a good deal , in my opinion.
-- "John Bossert" <jbossert_at_usa.net> wrote in message news:3EEF701E.6080604_at_usa.net...Received on Tue Jun 17 2003 - 21:10:48 CDT
> Does anyone know of a tool that can be used to create an html report of
the
> system catalog?
>
> I'd like to be able to have users reference table and column information
(along
> with stored comments) via their browsers.
>
> Google doesn't find anything.
>
> Thanks,
>
> --
> John Bossert
>
> In what concerns you much, do not think that you
> have companions: know that you are alone in the world.
>
> -- Henry David Thoreau
>