| 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
Alan - First the bad news. Obviously you can't automatically get all that
information, but then you knew that.
The good news. I think you'll find that information to be very valuable. I try to collect that myself. A spreadsheet or Access database is probably as good a way as any. If you have a help desk, they may be able to store this information as a configuration (or CI) in their tool. Another piece of data to consider is the database links.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Tuesday, December 09, 2003 5:35 PM
To: Multiple recipients of list ORACLE-L
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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.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 Wed Dec 10 2003 - 09:14:25 CST
 |
 |