+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11
  1. 09-29-2008 03:29 PM #1
    midora
    midora is offline Member
    Join Date
    Aug 2008
    Posts
    113

    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,323
    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
    113
    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,323
    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,397

    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,323
    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
    113
    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,323
    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
    113
    table structure, fields, data types, those details please!!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

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