Tool to generate data dictionary

[Soni]

Does anyone know a tool or function in SQL Denveloper that ger a data dictionary?

Win XP
Oracle 10g

[diegolenhardt]

As well as:

there is the dbms_metadata bank package, which you can extract the code of your bank objects, (dbms_metadata.get_ddl)

exists in Oracle Export (exp) The option to export only the structure it would be:

Select all

exp user/senha@banco file=export.dmp rows=n;

In DataPump is also possible, through the Metadata option,

Is this what you want?

[Soni]

DBManager generates a dice diction in HTML and or RTF format is what Empassed in other tools

[diegolenhardt]

I think with the dbms_metadata will achieve, including it returns an XML, with the content, see there, the pl / sql developer also has option, generate ddl script,

I think much more interesting to have the .sql format scripts than HTML or RTF, I do not know what your case, anyway,

I would generate each bank object a .sql file,

[Soni]

It is that I need the dictionary of data for the monograph
The tables are ready and with the comments
DBDesign does but is not bringing in reverse engineering the comments (are the main part of the data dictionary) There you have to put in your hand.
If you have one more tip thank you

[diegolenhardt]

Is it not an option in the dbdesigner that is missing to mark?

In my monograph I used PowerDesigner, I can not remember the comments, but it is a very parrusting program, it will probably make the reverse yes, Erwin use here at work takes the comments, You want to try it.

=]

[Soni]

Diegolenhardt Thanks for the help
I managed with SQLDenveloper it has in the reports tab the option of "Data Dictionary Report" option that can be exported to XLS, HTML, TXT etc.

DBDesign When you mind the tables they do not bring the comments, I'vê tried several options and nothing.
Thanks