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