| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Documenting databases
Dan,
That's a good idea for documenting structures inside the database. However, my database manager wants more high level info: database name / host, oracle version, listeners, applications that use it, cron job descriptions and times, main schemas and what they are used for, lists of developers names that access the databse, etc...
Alan
Daniel Hanks
<hanksdc_at_about-in To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
c.com> cc:
Sent by: Subject: Re: Documenting databases
ml-errors_at_fatcity
.com
12/09/2003 04:09
PM
Please respond to
ORACLE-L
On Tue, 9 Dec 2003 alan.aschenbrenner_at_ihs.com wrote:
> Recently our database manager has asked us to do the unthinkable....
> document our databases! To make matters worse, and without our input, he
> went ahead and created a schema and put it in an Access database (using
> tables to make it look like a speadsheet). Either we use his idea or
come
> up with something else.
> So, I thought I'd ask everyone on the list how you do it. Text
files?
> In a database (oracle, or other)? Spreadsheets? What are the pros and
> cons? Etc....
>
How about in each database itself.
COMMENT ON TABLE|COLUMN tab|tab.col IS '...'
comes to mind. It's simplistic, yes, but at least you don't have to remember where you put your documentation...
HTH,
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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: alan.aschenbrenner_at_ihs.com 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 Tue Dec 09 2003 - 17:34:32 CST
 |
 |