Data Dictionary report

Hi ,

How can i export the Data Dictionary in to one report instead of running it for repeatedly for 400 tables?

Please guide!!

Thanks

do what? sorry that doesnt make sense - you cant export the data dictionary

do you mean you want to extract the DDL for your tables?

Hi,

I meant to say is i want to create HTML report for whole data Dictionary!! Is it possible if so how can i start it!! Please guide!!

Thanks

sorry makes no sense, what do you want in this report?

1) Use SQL Developer or TOAD to extract schema DDL.

2) Do an exp with rows=n and use DDL Wizard

3) Try out Plato

:p

Hi,
For HTML output file you shall try SET MARKUP HTML ON SPOOL ON from SQL*PLUS. Start spool, run the query and spool off. The spooled file will be in the HTML format.

whats still missing from this thread is what is supposed to be in the report!

I need to get all the table structure and details in one report!!

Thanks
Pat

what details! you are being really really vague

table structure, fields, data types, those details please!!

Quote:

---

Originally Posted by midora

table structure, fields, data types, those details please!!

---

Like the details you can find on dba_tab_columns perhaps?