Tablespace Creation in Trouble..
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Tablespace Creation in Trouble..

  1. #1
    Join Date
    Feb 2001
    Posts
    184

    Angry

    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

  2. #2
    Join Date
    Sep 2000
    Posts
    78
    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
    Posts
    184
    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
    Posts
    1
    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.

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

    Thanks

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