RE: datafile permissions
- From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
- To: <raja4list@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 5 Jul 2005 15:30:03 -0600
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of raja rao
Sent: Tuesday, July 05, 2005 3:20 PM
To: oracle-l@xxxxxxxxxxxxx
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.
Other related posts:
