I checked with one of my friend who is a Network/System Admin.
He says, may be you need to enable the "Guest" account in the Shared Server.
By default it is disabled.

HTH

GovindanK

-----Original Message-----
From: oraora oraora [mailto:[Email Address Removed] Thursday, January 30, 2003 7:04 PM
To: LazyDBA.com Discussion
Subject: how to create datafile in shared network drive ??


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.



_____________________________________________________________
Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus
Oracle LazyDBA home page