From oracle-l-bounce@freelists.org Tue Jul 5 16:34:49 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j65LYnsX009294 for ; Tue, 5 Jul 2005 16:34:49 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j65LYiIP009273 for ; Tue, 5 Jul 2005 16:34:45 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 87FDF1C829C; Tue, 5 Jul 2005 16:34:27 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 03542-04; Tue, 5 Jul 2005 16:34:27 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 033A11C8135; Tue, 5 Jul 2005 16:34:26 -0500 (EST) X-BigFish: V X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C581A8.78A436C7" Subject: RE: datafile permissions Date: Tue, 5 Jul 2005 14:28:22 -0700 Message-ID: <65C0D8935651CB4D96E97CEFAC5A12B944478E@wafedixm10.corp.weyer.pri> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: datafile permissions Thread-Index: AcWBqAkEMvC2yosVQAKGi72HBGVAhAAAEhqw From: "Khemmanivanh, Somckit" To: , X-OriginalArrivalTime: 05 Jul 2005 21:28:23.0182 (UTC) FILETIME=[78D7BAE0:01C581A8] X-archive-position: 22072 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: somckit.khemmanivanh@weyerhaeuser.com Precedence: normal Reply-To: somckit.khemmanivanh@weyerhaeuser.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.4 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_BLUE,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C581A8.78A436C7 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable =20 I don't think you have to do anything at the Oracle level. You're moving from more restrictive to less restrictive anyways... =20 Thanks!=20 =20 ________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of raja rao Sent: Tuesday, July 05, 2005 2:20 PM To: oracle-l@freelists.org Subject: datafile permissions Hi All, =20 Sun OS 2.9=20 oracle 9i =20 In what state the datafiles should be when i want to change the OS file permissions from 600 to 640=20 =20 chmod 640 *.dbf =20 I put the tablespace offline. is that enough?, or should i make the datafiles offline withi =20 alter database datafile 'filename' offline; =20 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 ? =20 =20 Thanks in advance, Raj __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around=20 http://mail.yahoo.com=20 ------_=_NextPart_001_01C581A8.78A436C7 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I don't think you have to do anything at the = Oracle level.=20 You're moving from more restrictive to less restrictive=20 anyways...

Thanks!

From: oracle-l-bounce@freelists.org=20 [mailto:oracle-l-bounce@freelists.org] On Behalf Of raja=20 rao
Sent: Tuesday, July 05, 2005 2:20 PM
To:=20 oracle-l@freelists.org
Subject: datafile=20 permissions

Hi All,

Sun OS 2.9

oracle 9i

In what state the datafiles should be when i want to change the OS = file=20 permissions

from 600 to 640

chmod 640 *.dbf

I put the tablespace offline. is that enough?, or should i = make the=20 datafiles offline withi

alter database datafile 'filename' offline;

I had a fight with my manager. He asked me to put the datafiles = offline=20 using alter database.

But Just i put the tablespace offline and did that. Just want to = make sure=20 what is

the right way (precautiion to be taken) for this task ?

Thanks in advance,

Raj

__________________________________________________
Do You = Yahoo!?
Tired=20 of spam? Yahoo! Mail has the best spam protection around=20
http://mail.yahoo.com

------_=_NextPart_001_01C581A8.78A436C7-- -- http://www.freelists.org/webpage/oracle-l