Ben Two ideas: 1. A site like yours probably has a source code control system. Use it. 2. Learn ITIL.
Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Thursday, March 20, 2003 2:04 PM To: Multiple recipients of list ORACLE-L Hi 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
