I don't think Oracle supports shares on Windows. It has to be a permanent drive (i.e. local, attached storage like EMC).
Imagine all the support calls they'd get because of unannounced network errors, people pulling the wrong plug... steve ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, January 30, 2003 8:58 PM > 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: 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).
