Tablespace Creation in Trouble..

[Oracledba8]

Hi,

Can any one please let me know what is wrong with this statement to create tablespace...

create tablespace newtabspace datafile 'c:\orawin95\database\newtabspace.ora' size 10m
autoextend on next 500k permanent
SQL> /
create tablespace newtabspace datafile 'c:\orawin95\database\newtabspace.ora' size 5m
*
ERROR at line 1:
ORA-19502: write error on file "c:\orawin95\database\newtabspace.ora", blockno
1 (blocksize=2048)
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
OSD-04026: Invalid parameter passed.
O/S-Error: (OS 64) The specified network name is no longer available.

Please advise me.. This is just practice.. on Windows Personal Oracle 8 ... Thanks

[siroracle]

the error suggets that the OS doesn't allow Oracle to write to the DB file. Is the location that u trying network mapped drive? Is there enough space to write? check for those things...

[Oracledba8]

Yes there is Plenty of space, and there is no write problem becuase this is Windows98, I can not figure it out why?

Please assist me.. Thanks

[mdeshpan]

Hello

Are you trying to run this command from MSDOS?
If yes why don't you try running this command from SQL*PLUS. I think it is problem with the enter character.
Else try increasing the memory parameter of MS-DOS window.

[Oracledba8]

I am running this command in SQL Plus with DBA Privs, This is one line, but in thread it spans 2 lines.

Thanks