Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 8i using MS NT network drive...

Re: Oracle 8i using MS NT network drive...

From: Yann CAUCHARD <yann.cauchard_at_spcconsultants.com>
Date: Fri, 7 Jan 2000 15:47:50 +0100
Message-ID: <854ucb$jed$1@news6.isdnet.net>


Have you the rights to create a file on the other PC ?

Scott Bell a écrit dans le message <38756571.E5A1D301_at_open.org>...
>Hi,
>
>I'm having problems creating a tablespace datafile on a networked MS
>NT4.0( patch level 5 ) machine from another MS NT4.0 machine using
>SQL*PLUS. I'll run the ALTER TABLESPACE INDEX_1 ADD DATAFILE
>'G:\orant\oradata\rep2\index02.dbf'. The 'G:' reference is the shared MS
>NT drive from the remote machine. I get an 'OS skgfce (5): cannot create
>file' error. I can add any file to any tablespace locally w/ the same
>ORACLE user.
>
>The frustrating thing is that, as user SBELL1 on the local machine I can
>create/copy/edit the same file to that G: drive via the MS-DOS shell
>window. Is ORACLE run under a different user when is spawns SQL*PLUS( or
>any other ORACLE app )? I've also given every user full access
>temporarily to see if that was it. No luck - same error.
>What gives? Your help would be appreciated!
>
>Thanks,
>Scott
>==================================================
>Scott Bell
>ORACLE DBA
>scott.bell_at_gte.telops.com
>==================================================
>
>
>
>------
>Posted via news://freenews.netfront.net
>Complaints to news_at_netfront.net
Received on Fri Jan 07 2000 - 08:47:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US