Re: NT data files

richard long wrote:
>
> I am moving from po7 form win95 to wgs7.3.3.0.0. The install has gone ok.
> Now when I start to do the following:
>
> create tablespace WEY
> datafile 'g:\WEY\dbs\dbswey.ora' size 15 M reuse
> default storage ( initial 1m next 10k minextents 1 maxextents 121
> pctincrease 0 )
> online
> /
> I get the following errors.
>
> ERROR at line 1:
> ORA-01119: error in creating database file 'g:\wey\dbs\ntwey1.ora'
> ORA-09200: sfccf: error creating file
> OSD-04002: unable to open file
> O/S-Error: (OS 1317) The specified user does not exist.
>
> This works in po7 justr fine. The date files do not reside on the sever
> but on a file sever on a network. The network is a Novell 4.0 lan. I've
> tried several users including creating a user with the network id. This
> seems to be an nt problem. In the above situation the g drive is a mapped
> drive as follows \\plwhqfs03\comm1\groups\gsgdata. Do all data files have
> to be local to an nt machine. ????

This should work just fine as long as you do not use the 'attached drive letter' in your filespec.

I believe I read this in one of the Oracle NT installation manuals a year ago or so (can't remember which manual). It has to do with network filesystem naming conventions.

Try '\\servername\sharename\<subdirectory>\filename.ora'

Let me know if this works.

Corry Retzke
Freelance Oracle Consultant
Somewhere in the Seattle Metropolitan Area Received on Sun Jun 22 1997 - 00:00:00 CDT