Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2006
    Posts
    17

    Question Unanswered: Tool to generate document of table list?

    Hi guys!
    Now we have a big problem. There are a lot of tables and views in our database. For reducing maintenance cost in the future, we begin to write document about it. But we find it is a so hard work to list the tables and columns in the table. So we think may be we can find a tool to do it automatically.
    Does anybody know a tool can do this work?

    any help is appreciated!

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Does anybody know a tool can do this work?
    SQL*Plus can list all the tables & columns
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Feb 2006
    Posts
    17
    I know SQL *Plus can do it.
    I also know I can write sql cmd to list.
    But I'd like to find another more convenient tool to generate document.
    I think may be this work will be repeated in the future in other project.

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    This is probably a sledge-hammer to crack a peanut but Oracle Designer can import all your table definitions from a schema into its repository where you can add descriptive notes etc. and produce reports.

  5. #5
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    I think may be this work will be repeated in the future in other project.
    Then why not write a sql cmd and save it as a script?
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  6. #6
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Also in Oracle 8 (at least) and above, a comment can be added to a table or a column. Self document the table in the database and then simply use sql*plus to dump the schema's with comments. Easy and Free.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  7. #7
    Join Date
    Nov 2002
    Posts
    833
    dbms_metadata.get_ddl('<object_type>','<object_nam e>');

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •