Steve, Oracle will allow you to create a datafile on a network drive. They just won't support you unless you have it on a supported storage system (like a NetApp Filer) and appriopriately configured (read that as meaning a dedicated TCP/IP cable).
Dick Goulet "Steve Perry" <[EMAIL PROTECTED]> wrote on 1/31/03 3:16 pm: 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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
