Hallo oraora,

oracle.exe runs normally as localsystem account and not as you.

I don't recommend it and Oracle too.

If you really want to do it:
Change the service that it runs as you.
Do that in Control Panel/Administration/Service
and change OracleService<SID>.

Don't do it, unless for testing.

Why would you want to do it?

Maybe for Parallel Option?

Friday, January 31, 2003, 4:03:49 AM, you wrote:
oo> the env. is 8.1.6/win2k.

SQL >> alter tablespace test add datafile
oo> '\\192.168.17.111\shared\test.dbf' size 100m;

oo> ORA-01119: error in creating database file
oo> '\\192.168.0.111\shared\test.dbf'
oo> ORA-27040: skgfrcre: create error, unable to create file
oo> OSD-04002: cannot open file.
oo> O/S-Error: (OS 5) access denied.

oo> But i have all access/permission to this drive.
oo> i mapped this shared network drive and then tried once again.
oo> even then i get the same error.


oo> Is it possible to create a tablespace with datafile residing in a
oo> shared network drive ??

cu
Wieland mailto:[Email Address Removed]Oracle LazyDBA home page