datafile permissions

  • From: raja rao <raja4list@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 5 Jul 2005 14:19:41 -0700 (PDT)

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 

Other related posts: