RE: datafile permissions

From: Reidy, Ron <Ron.Reidy_at_arraybiopharma.com>
Date: Tue, 5 Jul 2005 15:30:03 -0600
Message-ID: <17CAB0BF27BCFC47B0E4554A0E2F962B562B79@fiji.arraybp.com>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of raja rao Sent: Tuesday, July 05, 2005 3:20 PM
To: oracle-l_at_freelists.org
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.

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jul 05 2005 - 16:34:17 CDT