From oracle-l-bounce@freelists.org Thu Jun 17 16:24:56 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5HLOeB29242 for ; Thu, 17 Jun 2004 16:24:51 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i5HLOQ629203 for ; Thu, 17 Jun 2004 16:24:36 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CEE5672DD31; Thu, 17 Jun 2004 15:41:04 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09138-74; Thu, 17 Jun 2004 15:41:04 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 16BCE72CA9A; Thu, 17 Jun 2004 15:41:04 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 17 Jun 2004 15:39:42 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 07EF772DC3E for ; Thu, 17 Jun 2004 15:39:42 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09827-02 for ; Thu, 17 Jun 2004 15:39:41 -0500 (EST) Received: from mx10.radisys.com (mx10.radisys.com [206.102.10.36]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8DF6C72DC3C for ; Thu, 17 Jun 2004 15:39:41 -0500 (EST) Received: by mx10.radisys.com (Postfix, from userid 5) id AA2E1142DFA; Thu, 17 Jun 2004 14:00:20 -0700 (PDT) Received: from UNKNOWN(206.103.52.194), claiming to be "dcblackberry.radisys.com" via SMTP by mx10, id smtpdAAAjgQmS_; Thu Jun 17 14:00:08 2004 To: oracle-l@freelists.org Subject: Pre-Approved database changes MIME-Version: 1.0 X-Mailer: Lotus Notes Release 6.5.1 January 21, 2004 Message-ID: From: Jared.Still@radisys.com Date: Thu, 17 Jun 2004 14:00:05 -0700 X-MIMETrack: Serialize by Router on DCBlackBerry/Radisys_Corporation/US(Release 6.0.3|September 26, 2003) at 06/17/2004 01:53:36 PM, Serialize complete at 06/17/2004 01:53:36 PM Content-Type: multipart/alternative; boundary="=_alternative 00735B1088256EB6_=" X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2937 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Jared.Still@radisys.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org --=_alternative 00735B1088256EB6_= Content-Type: text/plain; charset="US-ASCII" Dear List, Those of you with stringent change control standards, or are currently going through Sarbanes Oxley, may be familiar with pre-approved changes. Essentially, all changes will be logged to the change control repository. Yes, all. There will be a list of pre-approved changes. These are changes that may be performed without review by the change control board. These are things that are naturally done throughout the course of the day as part of normal DBA duties. These changes are of a nature that the outcome is always predictable, and does not result in accidental downtime or outages, or have other profoundly negative results. Keep in mind that there is an assumed level of competence and some discretion involved on the part of the DBA. You could probably perform just about any database operation and cause problems if you don't know what you are doing or act as if you are the only user on the system. Examples: adding datafiles to a tablespace changing storage parameters on an index or table modifying database statistics through collection or deletion create exports create backups online index rebuilds ( in the rare case that it is useful ) Vertex Tax Table loads( yes, I'm stuck with those ) These changes are assumed to occur on active database systems, and are not part of some other normally scheduled procedure, such as a data load. I would like to add to this list, and will welcome all suggestions and/or corrections. If it is substantial, I will post it somewhere that all can access it. Thanks, Jared PS. It's due tomorrow. ;) --=_alternative 00735B1088256EB6_= Content-Type: text/html; charset="US-ASCII"
Dear List,

Those of you with stringent change control standards, or are currently going
through Sarbanes Oxley, may be familiar with pre-approved changes.

Essentially,  all changes will be logged to the change control repository.

Yes, all.

There will be a list of pre-approved changes.  These are changes that may
be performed without review by the change control board.

These are things that are naturally done throughout the course of the day as part
of normal DBA duties.  These changes are of a nature that the outcome is always
predictable, and does not result in accidental downtime or outages, or have other
profoundly negative results.

Keep in mind that there is an assumed level of competence and some
discretion involved on the part of the DBA.  You could probably perform
just about any database operation and cause problems if you don't know
what you are doing or act as if you are the only user on the system.

Examples:

adding datafiles to a tablespace
changing storage parameters on an index or table
modifying database statistics through collection or deletion
create exports
create backups
online index rebuilds  ( in the rare case that it is useful )
Vertex Tax Table loads( yes, I'm stuck with those )


These changes are assumed to occur on active database systems, and are
not part of some other normally scheduled procedure, such as a data load.

I would like to add to this list, and will welcome all suggestions and/or corrections.

If it is substantial, I will post it somewhere that all can access it.

Thanks,

Jared

PS. It's due tomorrow.   ;)

--=_alternative 00735B1088256EB6_=-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------