Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h137Oq415732 for ; Mon, 3 Feb 2003 01:24:52 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h137Opm15727 for ; Mon, 3 Feb 2003 01:24:51 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id UAA98265; Sun, 2 Feb 2003 20:08:01 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00541A46; Sun, 02 Feb 2003 19:23:43 -0800 Message-ID: Date: Sun, 02 Feb 2003 19:23:43 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Richard Ji Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Richard Ji Subject: RE: how to create datafile in shared network drive ?? Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit They are correct that they don't want you to do it. The only approved NAS solution by Oracle is Network Appliance's product. Other NFS, shared drive etc aren't good idea to put Oracle database files. -----Original Message----- Sent: Friday, January 31, 2003 6:16 PM To: Multiple recipients of list ORACLE-L Thanks for correcting me Richard. I had tried that in the past and Oracle had said it couldn't be done nor would they want me doing it. I agreed after thinking about it. steve ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" Sent: Thursday, January 30, 2003 9:49 PM > Check out this metalink note: > > Note:211532.1 > > -----Original Message----- > Sent: Thursday, January 30, 2003 9:59 PM > To: Multiple recipients of list ORACLE-L > > > Guys, > > the env. is 8.1.6/win2k. > > SQL > alter tablespace test add datafile > '\\192.168.17.111\shared\test.dbf' size 100m; > > ORA-01119: error in creating database file > '\\192.168.0.111\shared\test.dbf' > ORA-27040: skgfrcre: create error, unable to create file > OSD-04002: cannot open file. > O/S-Error: (OS 5) access denied. > > But i have all access/permission to this drive. > i mapped this shared network drive and then tried once again. > even then i get the same error. > > > Is it possible to create a tablespace with datafile residing in a > shared network drive ?? > > TIA. > > Prem. > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: oraora oraora > INET: oraoraora@rediffmail.com > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Richard Ji > INET: richard.ji@mobilespring.com > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve Perry INET: sperry@sprynet.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: richard.ji@mobilespring.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).