The internal stuff can be documented with OraSnap.
Just google for it. It's free, detailed, and easy to setup and automate.
Jared
|
| alan.aschenbrenner@ihs.com
Sent by: ml-errors@fatcity.com
12/09/2003 03:34 PM
Please respond to ORACLE-L
|
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
cc:
Subject: 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@about-in To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
c.com> cc:
Sent by: Subject: Re: Documenting databases
ml-errors@fatcity
.com
12/09/2003 04:09
PM
Please respond to
ORACLE-L
On Tue, 9 Dec 2003 alan.aschenbrenner@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,
-- Dan
========================================================================
Daniel Hanks - Systems/Database Administrator
About Inc., Web Services Division
========================================================================
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daniel Hanks
INET: hanksdc@about-inc.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@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@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@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: Jared.Still_at_radisys.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 - 18:19:24 CST
