-
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?
-
Plato?
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
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
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!!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|