add datafile to shared drive??? [message #51464] |
Thu, 23 May 2002 17:32 |
George
Messages: 68 Registered: April 2001
|
Member |
|
|
Hi,
I try to add a datafile for one of the tbs on a SHARED DRIVE, I get all the permissions on the drive, but I get following errors when I add a datafile to it:
ALTER tablespace tridata add datafile '\machine_nametempdboracletridata03.dbf' SIZE 100M
*
ERROR at line 1:
ORA-01119: error in creating database file
'\machine_nametempdboracletridata03.dbf'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
Can you help me to solve it?
Thanks
|
|
|
|
Re: add datafile to shared drive??? [message #51474 is a reply to message #51464] |
Fri, 24 May 2002 05:52 |
Grant
Messages: 578 Registered: January 2002
|
Senior Member |
|
|
You may have access but the process running the Oracle processes doesn't. You need to add the user running the Oracle processes to the administrator's group and then give them access to the drive. If you are using SYSTEM and do not want to give it admin rights then create a user and give it admin and change the Oracle processes to run under that user and give it rights to the drive.
|
|
|