RE: how to create datafile in shared network drive ??

They are correct that they don't want you to do it. The only approved NAS solution by Oracle is Network Appliance's product. Other NFS, shared drive etc aren't good idea to put Oracle database files.

-----Original Message-----
Sent: Friday, January 31, 2003 6:16 PM
To: Multiple recipients of list ORACLE-L

Thanks for correcting me Richard.

I had tried that in the past and Oracle had said it couldn't be done nor would they want me doing it.
I agreed after thinking about it.

steve

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, January 30, 2003 9:49 PM

> Check out this metalink note:
>
> Note:211532.1
>
> -----Original Message-----
> Sent: Thursday, January 30, 2003 9:59 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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: oraoraora_at_rediffmail.com
>
> 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: ListGuru_at_fatcity.com (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: Richard Ji
> INET: richard.ji_at_mobilespring.com
>
> 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: ListGuru_at_fatcity.com (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: sperry_at_sprynet.com

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: ListGuru_at_fatcity.com (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: Richard Ji
  INET: richard.ji_at_mobilespring.com

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: ListGuru_at_fatcity.com (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).