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
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
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
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...
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
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.
I am running this command in SQL Plus with DBA Privs, This is one line, but in thread it spans 2 lines.
Click Here to Expand Forum to Full Width