RE: datafile permissions

I was able to do it withoiut issues in the first shot, still want to make sure 
which
is the correct way.

"Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx> wrote:
I have done this without taking anything offline.  Try it on a test DB - your 
mileage could vary.
 
See the man page: http://unixhelp.ed.ac.uk/CGI/man-cgi?chmod
 
----------------- 
Ron Reidy 
Lead DBA 
Array BioPharma, Inc. 
 
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On 
Behalf Of raja rao
Sent: Tuesday, July 05, 2005 3:20 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: datafile permissions


Hi All,
 
Sun OS 2.9 
oracle 9i
 
In what state the datafiles should be when i want to change the OS file 
permissions
from 600 to 640 
 
chmod 640 *.dbf
 
I put the tablespace offline.  is that enough?, or should i make the datafiles 
offline withi
 
alter database datafile 'filename' offline;
 
I had a fight with my manager. He asked me to put the datafiles offline using 
alter database.
But Just i put the tablespace offline and did that. Just want to make sure what 
is
the right way (precautiion to be taken) for this task ?
 
 
Thanks in advance,
Raj

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


---------------------------------
This electronic message transmission is a PRIVATE communication which contains 
information 
which may be confidential or privileged. The information is intended to be for 
the use of the individual 
or entity named above. If you are not the intended recipient, please be aware 
that any disclosure, 
copying, distribution or use of the contents of this information is prohibited. 
Please notify the sender 
of the delivery error by replying to this message, or notify us by telephone 
(877-633-2436, ext. 0), 
and then delete it from your system.


                
---------------------------------
Yahoo! Sports
 Rekindle the Rivalries. Sign up for Fantasy Football

Other related posts: