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

In article <38760AC2.69D57359_at_gaul-edin.freeserve.co.uk>,   "Ken Gaul (06)" <ken_at_gaul-edin.freeserve.co.uk> wrote:
> 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.

Ken,
  The 'G' drive actually points to a shared drive on the server machine. The server-side drive label is 'D'; the full network path for the share is \\GTEORA2\D:\.

   What user from the Oracle side is trying to create the file - SYSTEM?

Thanks,
Scott
>
> 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jan 12 2000 - 10:54:53 CST