RE: How do you document your databases

From: Freeman Robert - IL <FREEMANR_at_tusc.com>
Date: Thu, 20 Mar 2003 15:00:23 -0600
Message-Id: <24726.322580@fatcity.com>

If you are using 9i, you can use the dbms_metadata procedure to generate DDL for your database objects.

-----Original Message-----
From: Ben
To: Multiple recipients of list ORACLE-L Sent: 3/20/2003 2:03 PM
Subject: How do you document your databases

How do you document your databases? The only DBA tool that I have at my disposal is Designer but I have not used it yet. Is it adequate to completely document the life cycle of a database design? I am sure it can
create and retain pretty straight forward DDL. Does it allow build levels?
What do you do with the DBA tinkering - things like which tablespace a table
goes into, storage clauses, parameters like PCTFREE, PCTUSED,etc? Where do
you document your pfile?

What about when you have to alter a table after the database is in production?
Do you document the alter script itself or do you go back and change the original DDL?

Then there are things like SQL*LDR control files, security (all the grants)
and all the auditing that has been turned on. Where do you keep all this stuff? Thanks in advance for any advice.

Ben

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Ben
INET: poelsb_at_post.queensu.ca

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Mar 20 2003 - 15:00:23 CST