RE: How do you document your databases

Oracle Designer is a very powerful tool. In a previous life, everything was handle in Designer, even shell scripts
(via Samba), word docs,...

We were using the version control to manage dev, test, qa, prod,... Each version was containing DDL, word docs, shell, C programs,...

We were 2 dev dba/architect to develop procedures and maintain everything in Designer. There was a third person just to manage the application version and manage implementation schedule.

You'll need upper management behind you to be able to develop and maintain a rigorous environment.

Stephane

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Ben Sent: Thursday, March 20, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L Subject: How do you document your databases

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: 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).