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

Steve,
 Oracle will allow you to create a datafile on a network drive. They just won't support you unless you have it on a supported storage system (like a NetApp Filer) and appriopriately configured (read that as meaning a dedicated TCP/IP cable).

Dick Goulet

"Steve Perry" <sperry_at_sprynet.com> wrote on 1/31/03 3:16 pm:

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: 
  INET: dgoulet_at_vicr.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).