Data Dictionary report
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Data Dictionary report

  1. #1
    Join Date
    Aug 2008
    Posts
    116

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    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?

  3. #3
    Join Date
    Aug 2008
    Posts
    116
    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

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    sorry makes no sense, what do you want in this report?

  5. #5
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,443

    Talking 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

  6. #6
    Join Date
    Jun 2006
    Location
    Chennai, INDIA
    Posts
    72

    Red face

    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.

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    whats still missing from this thread is what is supposed to be in the report!

  8. #8
    Join Date
    Aug 2008
    Posts
    116
    I need to get all the table structure and details in one report!!

    Thanks
    Pat

  9. #9
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    what details! you are being really really vague

  10. #10
    Join Date
    Aug 2008
    Posts
    116
    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
  •  



Click Here to Expand Forum to Full Width