problem creating tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: problem creating tablespace

  1. #1
    Join Date
    Apr 2001
    Location
    Berlin
    Posts
    65
    I tried to create a tablespace. Unfortunaley, I did not have enough space so I received this error below

    create tablespace DATA_2001
    *
    ERROR at line 1:
    ORA-19502: write error on file
    "/u01/ora01/mydata_2001.dbf", blockno 385601
    (blocksize=4096)
    ORA-27063: skgfospo: number of bytes read/written is incorrect
    IBM AIX RISC System/6000 Error: 28: No space left on device
    Additional information: -1
    Additional information: 262144
    ORA-19502: write error on file
    "/u01/ora01/mydata_2001.dbf", blockno 386177
    (blocksize=4096)
    ORA-27063: skgfospo: number of bytes read/written is incorrect
    IBM AIX RISC System/6000 Error: 28: No space left on device
    Additional information: -1
    Additional information: 262144



    Now I have a lot of space. So Idecided to go back to create the same tablespace again. But now I am getting the message that the file already exists.



    create tablespace DATA_2001
    *
    ERROR at line 1:
    ORA-01119: error in creating database file
    '/u01/ora01/mydata_2001.dbf'
    ORA-27038: skgfrcre: file exists


    Any help will be apprecitaed.

    OS/AIX
    DATABASE VERSION:8.1.5.0.0

  2. #2
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    Did you delete the file from the aborted attempt to create the tablespace? oracle will not remove the leftovers. in general, oracle does not manage files from the OS when you do any database drops, deletes or renames.

    d.

  3. #3
    Join Date
    Apr 2001
    Location
    Berlin
    Posts
    65
    okay. So I'm thinking that I have to delete the file from the OS level. Can you give me the command to do this in unix assuming the datafile name is "/u01/ora01/mydata_2001.dbf''.

    I'm new to unix so I want to make sure that I am deleting the right stuff. I will aprreciate an example.

    I'm running AIX.

  4. #4
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Command to delete a file in UNIX: rm (file_name)
    -
    example: rm /u01/ora01/mydata_2001.dbf

  5. #5
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    ahh, did not realize you're a newbie to unix, too. the command is "rm" (obvious, right?). to be really sure, use the -i flag to confirm the name. e.g.

    rm -i /u01/ora01/mydata_2001.dbf

    git yerself a good unix starter book soon. it will make your life easier.

    d.

  6. #6
    Join Date
    Apr 2001
    Location
    Berlin
    Posts
    65
    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