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.



Oracle LazyDBA home page