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

Thread: Data Dictionary report

  1. 09-29-2008, 03:29 PM #1
    midora
    midora is offline Member
    Join Date
    Aug 2008
    Posts
    123

    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
    Reply With Quote Reply With Quote
  2. 09-29-2008, 03:31 PM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    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?
    Reply With Quote Reply With Quote
  3. 09-29-2008, 03:54 PM #3
    midora
    midora is offline Member
    Join Date
    Aug 2008
    Posts
    123
    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
    Reply With Quote Reply With Quote
  4. 09-29-2008, 04:14 PM #4
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    sorry makes no sense, what do you want in this report?
    Reply With Quote Reply With Quote
  5. 09-29-2008, 04:17 PM #5
    LKBrwn_DBA's Avatar
    LKBrwn_DBA
    LKBrwn_DBA is offline Senior Advisor
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    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
    Reply With Quote Reply With Quote
  6. 09-30-2008, 02:55 AM #6
    Kamkan
    Kamkan is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  7. 09-30-2008, 03:58 AM #7
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    whats still missing from this thread is what is supposed to be in the report!
    Reply With Quote Reply With Quote
  8. 09-30-2008, 08:43 AM #8
    midora
    midora is offline Member
    Join Date
    Aug 2008
    Posts
    123
    I need to get all the table structure and details in one report!!

    Thanks
    Pat
    Reply With Quote Reply With Quote
  9. 09-30-2008, 09:01 AM #9
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    what details! you are being really really vague
    Reply With Quote Reply With Quote
  10. 09-30-2008, 09:34 AM #10
    midora
    midora is offline Member
    Join Date
    Aug 2008
    Posts
    123
    table structure, fields, data types, those details please!!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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