Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How do you document your databases
If you are using 9i, you can use the dbms_metadata procedure to generate
DDL for your database objects.
RF
-----Original Message-----
From: Ben
To: Multiple recipients of list ORACLE-L
Sent: 3/20/2003 2:03 PM
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). Received on Thu Mar 20 2003 - 15:00:23 CST