Hi:

Along with Andrew's excellent analysis you may want to read more
about "Seriously baaaaddddd idea" of using network drives for
datafiles:

http://asktom.oracle.com/

Search/Archives
Search [network drive] Go!

Q (2): How to access .DBF files using 'shared' Win/NT network drives

Regards,
js


On 31 Jan 2003, oraora oraora wrote:

> Date: 31 Jan 2003 03:03:49 -0000
> From: oraora oraora <[Email Address Removed] To: LazyDBA.com Discussion <[Email Address Removed] 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.
>
>
>
>
> --------
> Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>

---------------------------------------------------------------------------
Jaroslav Smucr
EN-DATA, a.s. e-mail (MIME capable): [Email Address Removed] OS/DB Department Phone : +420 37 800 2962
Guldenerova 19, 303 28 Plzen Fax : +420 37 800 2962
Czech Republic, Europe
---------------------------------------------------------------------------



Oracle LazyDBA home page