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

This might be a stupid question but are you saying that on the DB Server machine the path to the file is G:\orant.... Or would it be c:\orant\oradata...? Don't forget it is the server creating datafile so the drive need not be shared to the machine where you are trying run the command.

Ken.

Scott Bell wrote:

> 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 - 09:48:18 CST