datafile permissions

From: raja rao <raja4list_at_yahoo.com>
Date: Tue, 5 Jul 2005 14:19:41 -0700 (PDT)
Message-ID: <20050705211941.82924.qmail@web31412.mail.mud.yahoo.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 05 2005 - 16:26:19 CDT