DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2001



    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

  2. #2
    Join Date
    Sep 2000
    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...

  3. #3
    Join Date
    Feb 2001
    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

  4. #4
    Join Date
    Mar 2001

    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.

  5. #5
    Join Date
    Feb 2001
    I am running this command in SQL Plus with DBA Privs, This is one line, but in thread it spans 2 lines.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.