Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Pre-Approved database changes

RE: Pre-Approved database changes

From: April Wells <AWells_at_csedge.com>
Date: Fri, 18 Jun 2004 07:29:27 -0500
Message-ID: <0C3690346404A94CBF4DDDD4724FC6141238350F@csmail.corpsys.csedge.com>

Killing user queries on request because they forgot there was a Cartesian product in it.

April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
 @>-->-->--
"Few people really enjoy the simple pleasure of flying a kite" Adam Wells age 11
"Imagination is the highest kite one can fly." Lauren Bacall

-----Original Message-----
From: bill thater [mailto:shrek_at_consultant.com] Sent: Friday, June 18, 2004 7:25 AM
To: oracle-l_at_freelists.org
Subject: Re: Pre-Approved database changes

> 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 )

adding/removing users
adding/removing roles
locking/unlocking accounts
password verification
adding/removing/modifing profiles
grant/revoke roles and/or privs

>
>
> 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. ;)
>

i love the sound deadlines make as they zoom by.;-)

--
Bill "Shrek" Thater     ORACLE DBA     
       shrek_at_consulant.com 
"I'm going to work my ticket if I can..." -- Gilwell song

------------------------------------------------------------------------
one ping to rule them all, one ping to find them,
one ping to bring them all, and in the mutex bind them.


-- 
___________________________________________________________
Sign-up for Ads Free at Mail.com
http://promo.mail.com/adsfreejump.htm


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_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
-----------------------------------------------------------------


The information contained in this communication, 
including attachments, is strictly confidential 
and for the intended use of the addressee only; 
it may also contain proprietary, price sensitive, 
or legally privileged information. Notice is hereby 
given that any disclosure, distribution, dissemination, 
use, or copying of the information by anyone other 
than the intended recipient is strictly prohibited 
and may be illegal. If you have received this communication 
in error, please notify the sender immediately by 
reply e-mail, delete this communication, and destroy 
all copies.

Corporate Systems, Inc. has taken reasonable precautions 
to ensure that any attachment to this e-mail has been 
swept for viruses. We specifically disclaim all liability 
and will accept no responsibility for damage sustained 
as a result of software viruses and advise you to carry 
out your own virus checks before opening any attachment.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_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
-----------------------------------------------------------------
Received on Fri Jun 18 2004 - 07:24:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US