Might one inquire _why_ you want to do this, especially if the "before"
file permissions are the result of your normal database creation
process? I too cannot see any immediate problem to running 'chmod' on
Oracle datafiles "on the fly", but is there a reason for incurring even
this small risk?
--
Mark Bole
http://www.bincomputing.com
raja rao wrote:
> Also can someone give me the insights what will happen when i do the chmod
> at os level and at oracle level how it things go.
>
> "Reidy, Ron" <Ron.Reidy_at_arraybiopharma.com> 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
>
[...]
>
> 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
>
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jul 05 2005 - 19:24:44 CDT
