Hi
did you check you have write permission on the shared folder where you
intend to place your datafile.

Even if you able create a datafile on the shared folder if the owner of the
folder removes the write permission you may a problem in accesing the
tablespace where the corresponding datafile exists in the shared folder.

vittal

----- Original Message -----
From: "oraora oraora" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Friday, January 31, 2003 8:33 AM
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

DISCLAIMER
---------------------------------------------------------------------------
This email message and any attachments is confidential and intended only for
the use of an individual or entity named above and may contain information
that is privileged, confidential or exempt from disclosure under applicable
law. If you are not the intended recipient, you are notified that any
dissemination, distribution or copying of this email is strictly prohibited.
If you have received this email in error, please notify us immediately by
return email or [Email Address Removed] and destroy the original message.
Opinions, conclusions, and other information in this message that do not
relate to the official business of SPAN, shall be understood to be neither
given nor endorsed by SPAN
________________________________________
Mails are Scanned and Filtered for Virus
[Email Address Removed]Oracle LazyDBA home page